Interested to Buy Any Domain ? << Click Here >> for more details...
how to get 25th row in any table in sqlserver can u tell me
syntax
- 8 Answers
- 12092 Views
- I also Faced
- E-Mail Answers
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
Why truncate is ddl command?
What is a trigger in sql server?
How to download and install the scaled-down database adventureworkslt?
What is difference between rownum and row_number?
What to perform pattern match with the like operator?
What do we need queues in sql service broker?
plss anybody specify tha constrian management system in dbms
What is difference between global temporary tables and local temporary tables?
Explain view in sql server?
What is the difference between deallocate cursor and close cursor?
is there a column to which a default can't be bound? : Sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Why main is user defined function?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
