我这个TABLE中只有十行数据,我想选中其中某个域数值为最大的一行,应该怎么写SQL语句?
我知道MS SQL SERVER 中是这样写的:
SET ROWCOUNT 1
SELECT * FROM AAA ORDER BY AAA.BBB DESC
SET ROWCOUNT 0
各位大虾,我在这里先谢谢各位了!
最初由 happyplus 发布
[B]SELECT * FROM TABLENAME WHERE ROWNUM < 2 ORDER BY A DESC [/B]
select * from
(select * from xxx order by adesc)where rownum =1;
select * from xxx where a = select max(a) from xxx;