Question

sql语句取最大值最小值

user_name money
admin 1
admin 10
admin 55

要求得到一条数据
admin 1 55
sql语句怎么写

Answer 1

select user_name, min(money),max(money) from table
group by user_name