select * from securitytest_64.userroles u where rowid = (selec

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

Question Posted / nagaraju jella

Answer Posted / nagaraju jella

select *
from securitytest_64.userroles u
where rowid =
(select max(rowid) from securitytest_64.userroles u
where rownum < 26)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

535

How to provide values to user defined function parameters?

553

How to download microsoft sql server 2005 express edition?

574

What is bcp? When does it use?

510

What is the difference between stored procedure and functions?

593

What are sql azure firewall rules?

Create and insert into temp table in sql server?

581

How to search for a string in all stored procedure in sql server?

534

What is a recursive stored procedure in sql server?

571

Does partitioning improve performance?

486

Explain about Joins?

603

How to execute a sql statement using odbc_exec()?

570

Why union all is faster than union?

506

What is the difference between a primary key and a unique key? Are they the same?

540

How can we migrate from SQL server to SQL Azure?