how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / pradyumna
set rowcount 25
declare @temptable table
(id int identity(1,1),itemid int)
insert @temptable
select itemid from tbl123
select * from tbl123 where itemid=(select itemid from
@temptable where id=25)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List types of tables in SQL Azure?
How to connect to SQL Azure Database by using sqlcmd?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is nested transaction?
What is default constraint in ms sql server?
Explain full-text query in sql server?
Write a program to fetch first 10 records from a file?
How to connect sql server management studio express to sql server 2005 express?
Does partitioning improve performance?
SQL Server Architecture ?
How to access the inserted record of an event?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
If user is owning any SQL Objects, can we drop that user
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is faster join or union?