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 subqueries in sql server? Explain its properties.

964

How many types of objects are there?

934

what is a schema in sql server 2005? : Sql server database administration

956

What is the difference between varchar and varchar types?

1001

Can you index views?

851

Explain aggregate functions?

1026

What are the indexes in sql server?

1022

Define Unique Key?

941

What is it unwise to create wide clustered index keys?

952

Can you explain full-text query in sql server?

969

What is the latest version of microsoft sql server?

962

Explain a differential backup?

947

What is trace flag in sql server?

975

State the difference between local and global temporary tables?

1047

What is replace and stuff function in sql server?

996