不同資料庫中查詢前10筆記錄的select用法

在不同資料庫中查詢前10筆記錄的Select用法

引用：http://blog.csdn.net/pric/archive/2004/09/19/109608.aspx

1. ORACLE SELECT * FROM TABLE1 WHERE ROWNUM<=10

2. INFORMIX SELECT FIRST 10 * FROM TABLE1

3. DB2 SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=10 或者SELECT COLUMN FROM TABLE FETCH FIRST 10 ROWS ONLY

4. SQL SERVER SELECT TOP 10 * FROM TABLE1

5. SYBASE SET ROWCOUNT 10 GOSELECT * FROM TABLE1

6. MYSQL SELECT * FROM TABLE1 LIMIT 10

7. FOXPRO SELECT * TOP 10 FROM TABLE ORDER BY COLUMN

http://blog.blueshop.com.tw/jacksun/archive/2007/02/28/49737.aspx

per檔中 folder 主畫面問題

程式如下:

SCHEMA FORMONLY LAYOUT

FOLDER

PAGE page01(TEXT="Page01")

GRID

{

Hello,world. This is page01

}

END END

PAGE page02(TEXT="Page02")

GRID

{

Hello,world. This is page02

}

END

END END

###################

畫面中看到的主畫面應該是 Page01, 不知為何會出現 主畫面

Vincent
2007.03.01