How to select nth record from a table?
- 13 Answers
- 37878 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
Explain intellisense for query editing
whats new about truncate in sql server 2008?
What are joins in sql and what are the different types of joins?
How do I view views in sql server?
What is sql server locking?
What are the difference between “where” and “having” clause in sql server?
How to create a simple table to test triggers in ms sql server?
Why can there be only one clustered index and not more than one?
Can I delete event logs?
What are the properties of sub-query?
What is normalization process?
How to override dml statements with triggers?
State the difference between local and global temporary tables?
How many types of triggers in sql server?
Explain try...catch with sql server?
