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
- 27758 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
What are sql server procedures?
What is the process of indexing?
What is measure group, measure? : sql server analysis services, ssas
What is multilevel indexing?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is the maximum rows in sql server table?
What is the default fill factor value?
What is the impact on other user sessions when creating indexes?
Which data type columns are the best candidates for full-text indexing?
Explain the ways to controlling cursor behavior?
Explain how dts is used to extract, transform and consolidate data?
What is self contained scalar sub query?
What is the use of sql profiler in sql server 2012?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
