几个数据库的取前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;