how to get 25th row in any table in sqlserver can u tell me
syntax
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 |
Post New Answer View All Answers
What is trigger and different types of Triggers?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is difference between index and primary key?
What is the rdl file?
What is difference between oltp and olap?
How to list all stored procedures in the current database using ms sql server?
How to assign null values to variables or columns?
How to make remote connection in database?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Are null values the same as that of zero or a blank space?
Explain the properties of a relational table?
Can you tell me about the concept of ER diagrams?
Explain a checkpoint?
When does a workload on SQL Azure get throttled?
What is the use of custom fields in report?