We create index colomn in that table . use that index coloum we take the

how to get 25th row in any table in sqlserver can u tell me
syntax

Question Posted / a.alagu ganesh

8 Answers
12289 Views
I also Faced
E-Mail Answers

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 is xdr?

1041

What is the simplest way to create a new database in ms sql server?

1050

How we create SQL Server 2005 Reporting Services ? Give me Sample

2042

List some case manipulation functions in sql?

1090

How many databases instances are there in sql server 2000?

1166

How to list all triggers in the database with sys.triggers in ms sql server?

1125

application server is slow what may be the problem

2270

Write the SQL query to drop, truncate and delete table.

1026

Can a database be shrunk to 0 bytes, if not, why?

1162

Explain what is “asynchronous” communication in sql server service broker?

957

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2125

Are connections to sql server encrypted?

1053

What does REVERT do in SQL Server 2005?

1011

Explain what are the authentication modes in sql server?

1071

How to add more data to the testing table in ms sql server?

1164