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

Are resultset updatable?

944

Explain different types of locks in sql server.

1068

Difference between report and query parameter. Why do we need different type of parameter?

941

What is difference between rollback immediate and with no_wait during alter database?

1079

What is a field in a table?

1031

Explain the steps needed to create a scheduled job?

917

How to see existing views in ms sql server?

1031

What is measure group, measure? : sql server analysis services, ssas

998

What is a livelock?

949

Please differentiate between a local and a global temporary table?

997

Why do we use trigger?

956

Do you know the different ddl commands in sql?

1040

Do you know what is normalization of database? What are its benefits?

1107

What is the difference between indexing and hashing?

1154

What is ms sql server reporting services?

1047