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
自己程序中用到的一点小东西,跟大家分享下。
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
自己程序中用到的一点小东西,跟大家分享下。
informix的first怎么你没讲?
SELECT first 20 * FROM app_event where Process_flag = 0 ORDER BY Id
在SQL2005和Oracle9开始都得到支持.