求条简单SQL语句
表结构如下
id a b
1 1 1
2 2 2
3 1 1
4 3 3
5 2 2
ID是递增的 用什么语句找出id最小的记录
[解决办法]
select min(id) id from tb
[解决办法]
SELECT * FROM TABLE1
WHERE ID =(SELECT MIN(ID) FROM TABLE1 )
[解决办法]
select * from table where id in (select min(id) from table)
