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

What is a trigger in sql server?

543

Can we shrink data file in sql server?

543

What is resultset concur_updatable?

590

What is a partitioned view?

576

How to throw custom exception in Stored Procedure?

588

What is replication with database mirroring? : sql server database administration

537

How many types of cursor type are there?

593

Do you know what are the reporting services components?

539

How to get nth highest salary from employee table.

625

What are the export options of ssrs?

126

How do you delete a trigger?

590

Explain trigger classes i.e. Instead of and after trigger?

495

What is sql server locking?

558

Explain partitioned view?

595

What is a print index?

508