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
What is attribute hierarchy? : sql server analysis services, ssas
What is the difference between update lock and exclusive lock?
How to view existing indexes on an given table using sys.indexes?
What do you understand by physical_only option in dbcc checkdb?
What are the encryption mechanisms in sql server?
What is checkpoint process in the sql server?
What is the difference between stored procedure and user defined functions?
Does an index slow down updates on indexed columns?
What is the largest component inside a field?
How to check table values in sql server?
How to specify the collation for a character data type in ms sql server?
How to get @@error and @@rowcount at the same time?
What are the new features in sql server 2016?
Do you know what is normalization of database? What are its benefits?
whats the maximum size of view state??