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
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Do you know what is openxml in sql server?
What do we have to check in database testing?
Explain what is dbcc?
What is a unique index?
What is query and its types?
What is 2nf normalization form?
Can you create a logon trigger in sql server 2005 express edition?
what is the main function of a query parameter?
What options are available to audit login activity? : sql server security
What are the different types of columns types constraints in the sql server?
What is the partitioning method?
Why would you use sql agent?
How to convert numeric values to integers in ms sql server?
what exactly sql injuction.how to overcome.....