Select TOP equivalencias en otros lenguajes

SQL Server / MS Access

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

SQL SELECT TOP equivalencia en MySQL and Oracle

MySQL

SELECT column_name(s)
FROM table_name
LIMIT number;

Ejemplo

SELECT *
FROM Persons
LIMIT 5;

Oracle

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

Ejemplo

SELECT *
FROM Persons
WHERE ROWNUM <=5;
Anuncios