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 trigger and different types of Triggers?

1149

Can you tell me some of the common replication dmv's and their use? : sql server replication

928

What is difference between index and primary key?

1100

What is the rdl file?

138

What is difference between oltp and olap?

1049

How to list all stored procedures in the current database using ms sql server?

1136

How to assign null values to variables or columns?

977

How to make remote connection in database?

1007

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

Are null values the same as that of zero or a blank space?

1040

Explain the properties of a relational table?

1024

Can you tell me about the concept of ER diagrams?

1078

Explain a checkpoint?

1039

When does a workload on SQL Azure get throttled?

131

What is the use of custom fields in report?

1000