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
- 26895 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manas
select * from
(select top 3 * from emp where empid in
(select top 7 * from emp where empid not in
(select top 4 * from emp order by empid)) order by empid
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How do you test your database? : sql server database administration
What is nonclustered index with included columns ?
How many types of built in functions are there in sql server 2012?
Is it ok to shrink transaction log?
What is BCNF? How is it better than 2NF & 3NF?
How do I open a .db file?
Tell me what is fill factor?
What is a data source file?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain mixed authentication mode of sql server?
What is a dbms wizard?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is policy based management (pbm)? : sql server database administration
Can we hide the definition of a stored procedure from a use?
