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

What do you understand by coalesce in sql server?

499


Explain time data type in sal server 2008?

552


What are the steps you should follow to start sql server in single-user mode?

488


What does ss stand for sexually?

589


How can you hide the sql server instances?

519






Explain what is sql server english query?

533


What are the advantages of having an index on the sql server?

545


How to use user defined functions in expressions?

554


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

522


Why can there be only one clustered index and not more than one?

546


How to connect of datebase with sql express.?

625


What is difference between rownum and rowid?

511


What is abstracting periodical?

529


What is star, snowflake and star flake schema? : sql server analysis services, ssas

660


How to use clusters?

553