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
- 12016 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
Explain the stored procedure?
What is the difference between for trigger and after trigger?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What the class forname () does?
What is difference between views and stored procedures?
What is the difference between web edition and business edition?
What are the different types of normalization?
How to use “drop” keyword in sql server and give an example?
Can we do dml on views?
How to create indexed view?
What is the purpose of indexing?
Will count(column) include columns with null values in its count?
Define the one-to-one relationship while designing tables.
How to use the inserted and deleted pseudo tables?
What is table level trigger?
