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
- 12284 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
System variable and temporary variables
What is user-defined functions? What are the types of user-defined functions that can be created?
What is coalesce in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is PROJECTION Operation?
Which sql server table is used to hold the stored procedure script?
Can a function call a stored procedure in sql server?
What are the different types of normalization?
Difference between report and query parameter. Why do we need different type of parameter?
How to disable triggers using "disable trigger"?
Why SQL Agent is used?
What are subqueries in sql server?
How many types of stored procedures are there in sql server?
What is the default fill factor value?
Explain tablesample?
