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

Tell me about normalization in DBMS.

1003

how many triggers you can have on a table? : Sql server database administration

987

can a database be shrunk with users active? : Sql server administration

1020

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

996

What are the different ways you can create databases in sql server?

1113

can an automatic recovery be initiated by a user? : Sql server administration

964

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1083

How do you implement session management in SQL Server mode?

1116

List out a number of the wants to setup a SQL Server failover cluster?

1076

What is the purpose of object explorer and its features? : sql server management studio

1221

Explain an incremental backup?

1009

How do we know if any query is retrieving a large amount of data or very little data?

980

How do I completely remove sql server instance?

1108

What are the grouping functions?

942

Using the customer, and order table in northwind database, please write a query to produce xml?

1082