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

21 Answers
26875 Views
IBM, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain an automatic checkpoint

958

Explain where clause?

976

What is full outer join in sql server joins?

1035

How do I install sql server?

873

What is exporting and importing utility?

1056

What is logon trigger?

1069

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

867

What are subqueries in sql server?

1096

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1025

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1113

What is a partition function in sql server?

1093

What is single-user mode?

912

How to override dml statements with triggers?

1152

Where is trigger in sql server?

1026

What is indexing in sql server with example?

982