Use of SELECT TOP Statement in SQL:
(1) “SELECT TOP” statement is used to get a specific number of records.
(2) Syntax of “SELECT TOP” statement is:
| SELECT TOP number column1, column2, … FROM table_name; |
(3) Let’s take an example to get specify records from the Vendor table as shown.
(4) Select the database in the SQL server and click on the “New Query” button as shown.
(5) After that new query editor open as shown.
(6) After doing the above steps, write a query in the editor, as shown.
Source Code:
| –// Without “TOP” statement in Vendor table Select [No_],[Name],[Address],[Country_Region Code] from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] –// Without “TOP” statement in Vendor table –// With “TOP” statement in Vendor table Select Top 5 [No_],[Name],[Address],[Country_Region Code] from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] –// With “TOP” statement in Vendor table |
(7) After writing the query, then execute the query (Shortcut keys is F5) as shown.
(8) After executing the two queries in the same editor, SQL gives two results. Note: Recommended write and execute query one by one for reporting.
