How to select nth record from a table?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / durga prasad

13 Answers
40377 Views
DELL, Microsoft, Ramco, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to select nth record from a table?..

Answer / soorai ganesh

SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS Rno,*
FROM Table_Name
)T
WHERE T.Rno = 7 -- If N is 7 other wise put ur nth value.

Is This Answer Correct ?

45 Yes

9 No

How to select nth record from a table?..

Answer / saravanan p

Select top 1 * from
(Select top n * from tbl order by column name asc)tbl1
order by column name desc

Is This Answer Correct ?

19 Yes

12 No

How to select nth record from a table?..

Answer / karthik

select * from (select rownum r , emp.* from emp)
where
r='&n'

Give the value of n. It will return the nth record.

Is This Answer Correct ?

13 Yes

8 No

How to select nth record from a table?..

Answer / pallavi attarde

Here N is for Nth record.

SELECT TOP 1 * FROM
(SELECT TOP N * FROM
(SELECT Table.Coloumn1,Table.Coloumn2 from Table)
as d order by d.Coloumn1 desc) as p order by Coloumn1

Is This Answer Correct ?

8 Yes

5 No

How to select nth record from a table?..

Answer / veeresh kethari

select min(sal) from EMP where sal in(select top n sal from
EMP
order by SAL desc)

Is This Answer Correct ?

3 Yes

0 No

How to select nth record from a table?..

Answer / 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

How to select nth record from a table?..

Answer / rathika

Answer #7 should be

select top 1 * from (select top n * from tbl order by col1
asc) tbl order by col1 desc

where n = nth number in the list

Is This Answer Correct ?

8 Yes

7 No

How to select nth record from a table?..

Answer / roxy

select top 1 * from (select top n * from tbl order by col1
desc) tbl order by col1 asc

where n = nth number in the list

Is This Answer Correct ?

5 Yes

5 No

How to select nth record from a table?..

Answer / andy

select a.id,a.name from dept a
where
1= (select COUNT(b.id) from dept b where b.id>a.id)

Is This Answer Correct ?

4 Yes

4 No

How to select nth record from a table?..

Answer / mohan krishna

declare @querry nvarchar(500)
declare @row varchar(10)
set @row = '5'

set @querry ='
select top 1 a.* from
(select * from vdpmaster..usermaster
where usr_id not in
(select top '
set @querry = @querry + @row + ' usr_id from
vdpmaster..usermaster)
)a'
print @querry
EXEC sp_executesql @querry

Is This Answer Correct ?

3 Yes

4 No

Post New Answer