how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / narayana
select * from emp order by empid
offset 4 rows
fetch next 3 rows only
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to provide column names in insert statements in ms sql server?
How will you monitor replication latency in transactional replication? : sql server replication
What is enhanced database mirroring in sql server 2008?
What are the properties of sub-query?
Explain the difference between clustered and non-clustered index?
Is INSTEAD OF trigger directly applicable to Table ?
Why transaction is important?
What are the restrictions that views have to follow? : SQL Server Architecture
Explain active/passive and active/active cluster configurations?
What is the Difference Between Primary and Foreign Key?
which backup strategy you are following at ur company
How to get nth highest salary from employee table.
What are the properties and different types of sub-queries?
What are rows and columns?
What is thr feature of change data capture?