How to select nth record from a table?
Answers were Sorted based on User's Feedback
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 |
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 ? | 18 Yes | 12 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How to call a function from a stored procedure in SQL Server ?
What are three SQL keywords used to change or set someone?s permissions?
Explain triggers in sql?
Tell me what do we need queues in sql service broker?
Do you know the capabilities of cursors?
How to tune a stored procedure?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is the difference between a primary key and a unique key? Are they the same?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Explain filtered indexes?
Explain datetimeoffset data type in sal server 2008?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?