几个数据库的取前20条数据SQL

几个数据库的取前20条数据SQL:

 

1.oracle:
    SELECT *  FROM ( SELECT ROWNUM SN, t.*  FROM App_event  t where  process_flag=0 ORDER BY t.id ) WHERE SN>0 AND SN <=20;

2.sqlserver:
    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

4.mysql:
    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;