select top 3 * from emp where id not in (select top 4 id from emp order by

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / priyanka

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

Please Help Members By Posting Answers For Below Questions

Explain the concept of view and Types of views in SQL server?

944

What are policy management terms?

935

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

Can I use sql azure as a backup with log shipping or database mirroring?

156

How to enforce security in sql server? : sql server security

1043

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

897

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

860

What is nonclustered index on computed columns?

907

Tell me about normalization in DBMS.

950

What are xml indexes?

894

What are different types of join?

1238

What is serializable?

999

Explain something about security and SQL Azure?

110

What is pivot and unpivot?

978

What is 2nf example?

943