如何查询sql表中年龄在30以上所有人员

1:select * from user where age>30 order by age
2:select * from user where age>50 order by age
3:select * from user where age>50 and address='省' order by age desc

select * from user where age>50 group by address order by age desc 这样执行是报错的，执行不过。

select * from user where age>30 order by age
select * from user where age>50 order by age

select * from user where age>50 group by address order by age desc

不知道对不对??

不对别见笑哈..
<<<<<<<<<<<<<<<<<<<<<<我认为他不是想知道哪一个省的..而是把所有结果中的是一个省的.放在一起....也就等于按省排列...

select * from [user] where age>30 order by age asc
select * from [user] where age>50 order by age asc
select * from [user] where age>50 group by address order bye age desc

首先有个问题，你订数据库的时候最好不要用user作为表名，user是个关键字很多情况下会出错误。
select * from user where age>30 order by age asc
select * from user where