how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / priyanka
select top 3 * from emp where id not in
(select top 4 id from emp order by id)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is clr ddl trigger?
Define left outer join?
What is use of except clause?
What is an entity-relationship diagram (erd)?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is enhanced database mirroring in sql server 2008?
How extra digits are handled with numeric data type literals?
How can I know what locks are running on which resource?
Describe in brief databases and sql server databases architecture.
What are the tools available in market as an alternative to sql server reporting services?
What is the cpu pressure?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
how to control the amount of free space in your index pages? : Sql server database administration
Please explain go command in sql server?
what is difference between view and Dip.