Steps to Limit Rows in SQL Server

Let’s check the steps to limit the number of rows on the SQL server. We will start by creating a table, then inserting records, and then using the TOP clause to limit rows.

Step 1: Creating the Database

Use the below SQL statement to create a database called w3wikiDatabase.

Query:

CREATE DATABASE w3wikiDatabase;

Step 2: Using the Database

Use the below SQL statement to switch the database context to w3wikiDatabase.

Query:

USE w3wikiDatabase;

Step 3: Create Table

Use the below SQL statement to create a table ‘Participant’

Query:

CREATE TABLE Participant (
 ID INTEGER PRIMARY KEY,
 Name TEXT NOT NULL,
 Percentage INTEGER NOT NULL,
 Branch TEXT NOT NULL
);

Step 4: Insert data into the table

Query:

INSERT INTO Participant VALUES
    (55, 'BB', 81, 'Civil'),
    (56, 'NN', 75, 'IT'),
    (57, 'RR', 100, 'CSE'),
    (58, 'SS', 94, 'Civil');

You can use the below statement to see the contents of the created table:

Query:

SELECT * FROM Participant;

Now let’s see how to use limit query here. To limit the resultant data for MS Access we use SELECT TOP syntax. LIMIT syntax works in MYSQL. In the Microsoft database, we use the below syntax (TOP which works similar to  LIMIT in MYSQL)

Step 5: Limit Rows Using TOP and ORDER BY

Use the TOP clause to limit rows in results set and ORDER BY statement to sort the results in ascending or descending order.

Syntax:

SELECT TOP(count) column1, column2, …,column n FROM table_name [WHERE your conditions] [ORDER BY expression [ ASC | DESC ]];

In the above syntax, WHERE conditions are optional conditions that must be true for the records to be selected.

ORDER BY expression is an optional statement in the query used to return the result in either ascending or descending order according to the keyword (ASC or DESC). Here count is the number of rows to be returned from the result.

To limit rows in SQL Server, use the TOP clause in the SELECT statement. Using the TOP clause in SQL Server, users can limit the number of rows in the results set.

Here, we will understand how to limit rows in SQL Server with the help of different examples.