-
SQL – Select Top Clause
SQL – Select Top Records Table Of Contents: What Is Select Top Records? Syntax Of Select Top Records. Examples Of Select Top Records. (1) What Is Select Top Records ? Sometimes you want to see only the top records. You can use the “SELECT TOP” clause to select top ‘n’ records. (2) Syntax Of Select Top Records ? Syntax: SQL Server / MS Access Syntax: SELECT TOP number|percent column_name(s) FROM table_name WHERE condition; Syntax: MySQL Syntax: SELECT column_name(s) FROM table_name WHERE condition LIMIT number; (3) Examples Of Select Top Records ? Demo Data: Example-1: SQL Server/MS Access SELECT TOP 3
