how to select 5 to 7 rows from a table, which contains 10 rows?
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 to connect sql server management studio express to sql server 2005 express?
What are the advantages of passing name-value pairs as parameters?
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?
What are the hotfixes and patches in sql server?
Can binary strings be converted into numeric or float data types?
How except clause is differs from not in clause?
How to search for a string in all stored procedure in sql server?
What is difference between index seek vs. Index scan?
How to find out the list schema name and table name for the database?
Which are ddl commands?
What method is used by the Command classes to execute SQL statements that return single values?
In what three ways is the return statement used in a stored procedure?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What are the new features in sql server 2016?
What is data compression?