几个数据库的取前20条数据SQL:
:
SELECT * FROM ( SELECT ROWNUM SN, t.* FROM App_event t where process_flag=0 ORDER BY ) WHERE SN>0 AND SN <=20;
:
SELECT top 20 * FROM app_event where Process_flag = 0 ORDER BY Id
3.db2:
SELECT * FROM ( select app_event.* ,rownumber() OVER( order by app_event.id )AS ROW_NEXT FROM app_event where app_event.Process_flag = 0)AS PRODUCT_TEMP WHERE ROW_NEXT BETWEEN 0 and 20
:
select * from app_event order by id limit 0,20
获取某列最大值所在行的数据:
1.
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
2.
SELECT article, dealer, priceFROM shopORDER BY price DESCLIMIT 1;