Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to select nth record from a table?

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 ?    18 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

More SQL Server Interview Questions

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers  


What are window functions in sql server?

0 Answers  


What options are available to audit login activity? : sql server security

0 Answers  


What is the difference between the application object and session object?

0 Answers  


What do you understand by triggers and mention the different types of it?

0 Answers  






Differentiate between a local and a global temporary table?

0 Answers  


What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,


How can you append an identity column to a temporary table?

0 Answers  


Can you force a query to use a specific index?

0 Answers  


How to use "begin ... End" statement structures in ms sql server?

0 Answers  


Do you know what are acid properties?

0 Answers  


what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  


Categories