表结构如下
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)