Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40354 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
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 indexed view? How to create it?
Explain how many types of relationship?
What is standby servers? Explain types of standby servers.
What to check if a User database is locked?
Explain what is the purpose of sql profiler in sql server?
Mention the different authentication modes in sql server.
Differentiate between sql temp table vs table variable?
Mention the different types of triggers?
Why normalization is used?
explain different types of cursors? : Sql server database administration
What is stretch database in sql server?
Can you get second highest salary from the table?
Explain about extended stored procedure?
What is merge replication?
What is RMS migrations?
