how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / a.alagu ganesh
We create index colomn in that table . use that index
coloum we take the 25th row of that table .
Example
SELECT * FROM table1 WHERE index_coloumn = 25
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Can you explain what is indexed view? How to create it?
What are the differences between left join and inner join in sql server?
Do you know the cursor optimization tips?
What are the steps to process a single select statement?
Explain about extended stored procedure?
which backup strategy you are following at ur company
Write SQL queries on Self Join and Inner Join.
When should you use an instead of trigger?
Which tcp/ip port does sql server run on? How can it be changed?
How to disable triggers using "disable trigger"?
How network traffic be reduced by using the stored procedure?
Mention the differences between substr and charindex in sql server.
Explain Geography datatype in SQL Server
what is an extended stored procedure? : Sql server database administration
How to recover from sql injection? : sql server security