1.写出如下要求的SQL语句
(表)t
a b(列)
1 2
1 3
1 4
2 1
2 2
3 1
4 1
5 3
5 2
查询结果要求
a b
1 2
2 1
3 1
4 1
5 2
答案:select a ,min(b) from t group by a
备注说明:如果按照b的最大值筛选则:
selet a,min(b) from t group by a
a b
1 4
2 2
3 1
4 1
5 3
1.写出如下要求的SQL语句
(表)t
a b(列)
1 2
1 3
1 4
2 1
2 2
3 1
4 1
5 3
5 2
查询结果要求
a b
1 2
2 1
3 1
4 1
5 2
答案:select a ,min(b) from t group by a
备注说明:如果按照b的最大值筛选则:
selet a,min(b) from t group by a
a b
1 4
2 2
3 1
4 1
5 3