why select Top 1 sql code example
Example: sql select top
-- SQL Server / MS Access Syntax:
SELECT TOP number|percent column_name(s) FROM table_name WHERE condition;
-- MySQL Syntax:
SELECT column_name(s) FROM table_name WHERE condition LIMIT number;
-- Oracle 12 Syntax:
SELECT column_name(s) FROM table_name ORDER BY column_name(s)
FETCH FIRST number ROWS ONLY;
-- Older Oracle Syntax:
SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;