Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40874 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
How many triggers are possible per table?
What is the meaning of sql server?
Where do you find the default Index fill factor and how to change it?
what are user defined datatypes and when you should go for them? : Sql server database administration
Why is normalisation important?
How many types of schemas are there?
How to disconnect from a sql server using mssql_close()?
Explain what is raid and what are different types of raid levels?
What is the default Port No on which SQL Server listens?
What is in place upgrade in sql server?
What is policy management?
How to read data in a table with "select" statements?
What are rest-style architecture's?
How does clustered and non clustered index work?
What is the Control Flow in SSIS
