SQL SERVER – How to select only Second row from a table?

To select only the second row from a table in a database, you can use SQL (Structured Query Language). Here's an example query:

If you're trying to select only the second row from a table in SQL, and the LIMIT clause is not working for you, you can use the OFFSET and FETCH clauses in combination. Here's how you can do it:

   SELECT * 
   FROM your_table_name 
   OFFSET 1 ROW 
   FETCH NEXT 1 ROW ONLY;

In this query:

• your_table_name is the name of your table.
• OFFSET 1 ROW skips the first row and starts selecting from the second row.
• FETCH NEXT 1 ROW ONLY fetches only one row from the result set.

This query will retrieve only the second row from your table. Make sure to replace your_table_name with the actual name of your table.

Examples

Consider we have following Employee table with table name Empl_Table which stores employee's ID, Name, Age, Salary, City and Country.

ID	Name	Age	Salary	City	Country
1	Rajesh	32	2000.00	Maryland	USA
2	Mukesh Raj	40	5000.00	New York	USA
3	Amit Kumar	45	4500.00	Muscat	UAE
4	Kaushik Dhan	25	2500.00	Kolkata	India
5	Hardik Kumar	29	3500.00	Bhopal	India

When we execute the SQL query as shown below,

   SELECT * 
   FROM  Empl_Table
   OFFSET 1 ROW 
   FETCH NEXT 1 ROW ONLY;

This will produce the following result:

ID	Name	Age	Salary	City	Country
2	Mukesh Raj	40	5000.00	New York	USA