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
- 27140 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
Ways to improve the performance of a SQL Azure Database?
Explain the commands in sql server?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Can a database be shrunk with users active?
Explain primary key?
How we create SQL Server 2005 Reporting Services ? Give me Sample
how many clustered indexes can be created on a table? : Sql server database administration
What is the difference between row_number and dense_rank?
What are trace flags and mention a few common trace flags used with sql server?
What is the difference between implicit and explicit transaction?
Tell me what are cursors and when they are useful?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is sql injection and why is it a problem? : sql server security
What is database replication?
