How to select nth record from a table?
Answer Posted / 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 View All Answers
What is conditional split?
How can you start sql server in different modes?
What is Cross Join and in which scenario do we use Cross Join?
Explain the microsoft sql server delete command?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are triggers? How do you invoke a trigger on demand?
what is the maximum size of a row? : Sql server database administration
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is the name of reporting services config file and what’s it’s used for?
How to change the name of a database user?
How are the unique and primary key constraints different?
what is bit datatype? : Sql server database administration
What are the differences between user defined functions and stored procedures?
Define normalisation?
What is a linked server in sql server?