how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21554 Views
- IBM, I also Faced
- E-Mail Answers
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
Do you know what is xpath?
Do I need a report server to run reports in my application?
How to rename an existing column with sql server management studio?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is a transactions?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Define full outer join in sql server joins?
How to find out the list schema name and table name for the database?
What is a non equi join?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
List some major differences between triggers and stored procedures?
What are the differences between char and varchar in ms sql server?
What are parameterized reports?
What is parameterized reports in ssrs ?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
