select * from yourtable where numfield = (select max(numfield) from yourtable )
查询最大值 select max(myNumberField) from myTable; 查询该记录,但是如果有很多条则全选 select * from myTable where myNumberField = (select max(myNumberField) from myTable); 查询该记录,但是如果有很多条只选一条 select * from mtTable where rowid = (select min(rowid) from myTable where myNumberField = (select max(myNumberField) from myTable));
select max(myNumberField) from myTable;
查询该记录,但是如果有很多条则全选
select * from myTable
where myNumberField =
(select max(myNumberField) from myTable);
查询该记录,但是如果有很多条只选一条
select * from mtTable where rowid =
(select min(rowid) from myTable
where myNumberField =
(select max(myNumberField) from myTable));