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

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

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

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

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

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

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

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

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

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

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

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.

What are window functions in sql server?

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

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

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

Differentiate between a local and a global temporary table?

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

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

Can you force a query to use a specific index?

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

Do you know what are acid properties?

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

Categories