sql top 10

Solutions on MaxInterview for sql top 10 by the best coders in the world

showing results for - "sql top 10"
Shayna
14 Mar 2017
1-- SQL Server / MS Access Syntax:
2SELECT TOP number|percent column_name(s) FROM table_name WHERE condition;
3-- MySQL Syntax:
4SELECT column_name(s) FROM table_name WHERE condition LIMIT number;
5-- Oracle 12 Syntax:
6SELECT column_name(s) FROM table_name ORDER BY column_name(s) 
7    FETCH FIRST number ROWS ONLY;
8-- Older Oracle Syntax:
9SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;