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


Please Help Members By Posting Answers For Below Questions

If we delete pack Spec what will be the status of pack Body ?

975


Explain how does the report manager work in ssrs?

506


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5509


How can we check the sql server version?

577


Which sql server table is used to hold the stored procedure script?

486






Which rendering formats are affected by the pagesize properties?

106


Explain the third normal form(3nf)?

527


What is the name of reporting services config file and what’s it’s used for?

107


How is a full-text index updated?

548


What are the restrictions that views have to follow? : SQL Server Architecture

543


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

612


Where is localdb stored?

578


How to transfer data from a cursor to variables with a "fetch" statement?

590


What is a rollup clause?

560


How to use union to merge outputs from two queries together in ms sql server?

567