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 store procedure? When do you use?
What is Extended user-defined?
Tell me something about security and sql azure?
What is a transactions?
Why is normalisation important?
What is a with(nolock)?
What is spid in sql server profiler?
Difference between report and query parameter.
Does sql server 2000 full-text search support clustering?
What is the maximum size of a row in sql server?
what are acid properties? : Sql server database administration
What are partitioned views?
What is indexed view?
How to execute function in stored procedure sql server?
What are the limitations in ssrs on sql server express edition?