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

How do you create a data source?

476

Tell me can we use custom code in ssrs?

601

What is db stored procedure?

469

What is the concept of optimization?

572

How to start and end transact-sql statements?

582

How do you debug a procedure in sql server?

498

What is sql injection? How to protect against sql injection attack?

557

How to convert a unicode strings to non-unicode strings?

565

What is difference between count (*) and count 1?

514

What is the chart in report?

111

Explain the xml support sql server extends?

623

Explain how many types of relationship?

575

How to reaname table name without using sp_Rename in sql server..?

530

What is stored in the mssqlsystemresource database? : sql server database administration

596

Can You Use Data Mining Models In Ssrs?