DB研討會 : [分享]SQL SELECT TOP Clause

SELECT TOP number|percent column_name(s) FROM table_name;

SELECT column_name(s) FROM table_name LIMIT number;

SELECT * FROM Persons LIMIT 5;

SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;

SELECT * FROM Persons WHERE ROWNUM <=5;

SELECT TOP 2 * FROM Customers;

SELECT TOP 50 PERCENT * FROM Customers;

Select Top 1 * from Table1 Where ID = '9527'

SELECT         * FROM
(
  SELECT         *
  FROM           Table1
  WHERE          (ID = '9527')
)
WHERE         (ROWNUM < 2)