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 is database replication? What are the different types of replication you can set up in sql server?

1017

What is a ddl statement?

961

What is normalization according to you and explain its different levels?

994

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1133

How to convert numeric expression data types by assignment operations?

1135

Explain a checkpoint?

1085

What are audit control procedures?

1034

What is mssql?

1031

How to change the data type of an existing column with "alter table" statements in ms sql server?

1035

Why I am getting this error when dropping a database in ms sql server?

1118

Define Wed Edition in SQL Azure?

102

What does truncate do?

992

What to perform pattern match with the like operator?

931

Difference between report and query parameter.

1142

How to create a large table with random data for index testing in ms sql server?

1067