select * from (select row_number() over(order by empid) rno,* from tbl)

How to select nth record from a table?

Question Posted / saravanan p

Answer Posted / saravanan p

select * from
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the significance of null value and why should we avoid permitting null values?

532

What is a rollup clause?

547

What is difference between primary key and foreign key?

482

How to set a database state to offline in ms sql server?

540

What is dbcc?

736

What is the partitioning method?

531

What is #table in sql server?

537

Explain insert into select statement?

525

Mention the different authentication modes in sql server.

536

Do comments need to go in a special place in sql server 2005?

513

Which is faster statement or preparedstatement?

536

What functions can a view be used to performed?

626

How do you debug a procedure in sql server?

498

What are the properties of the transactions?

616

Explain collation?

622