Select top N records in T-SQL / SQL Server

visibility 69 access_time 3y languageEnglish

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

In SQL Server, use TOP (N) to retrieve the first N records in the table. Remember to replace N with one actual number.

Code snippet

SELECT TOP (N) * FROM TableName;
info Last modified by Raymond 3y copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.28
local_offer Tags