Interested to Buy Any Domain ? << Click Here >> for more details...
how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 27741 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ayyappanramachandran
You can achieve this by using following Query
select * from(select top 3 * from employees where
employeeid in(select top 7 employeeid from employees where
employeeid not in(select top 4 employeeid from employees
order by employeeid)))e order by employeeid.
Thanks
AyyappanRamachandran
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What do you mean by collation recursive stored procedure?
What is the use of floor function in sql server?
In which sql server version report builder introduced?
Why we use trigger in sql server with example?
What do we need queues in sql service broker?
How to install sql server 2005 express edition?
What happens if ntwdblib.dll is missing on your machine?
What is the purpose of optimization?
What is the stuff?
How to execute a stored procedure in ms sql server?
Can you move the resources after pausing the node? : sql server database administration
What are data resources?
How will you hide an attribute? : sql server analysis services, ssas
What are views used for?
What is raiseerror? What is raiseerror?
