how to select 5 to 7 rows from a table, which contains 10 rows?
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 are different types of raid configurations? : SQL Server Architecture
What are the operating modes in which database mirroring runs?
How to create new table with "create table" statements?
What are drilldown reports?
What are the benefits and tasks of object explorer? : sql server management studio
Where can you find the error log information? : sql server database administration
What are the steps you must follow to hide sql server instances?
What is subreport?
What is stretch database in sql server?
What function does a database engine serve in the sql server?
What is query optimization process?
What is a cursor, index in sql?
What are window functions in sql server?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What are the advantages of stored procedure in sql server?