how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21693 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 is the new security features added in sql server 2014? : sql server security
What is “asynchronous” communication in sql server service broker?
How to convert a numeric expression from one data type to another?
Which sql server is best?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is indexing and its types?
How to view the error log for any specific instance? : sql server database administration
What are the different types of normalization?
What is the maximum length of an alert name?
What is autocommit mode in sql server?
What is the purpose of indexing?
What is the security principal at the database level that represents your session?
what is a transaction and what are acid properties? : Sql server database administration
What the class forname () does?
Can an entity have two primary keys?
