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

Can you explain powershell included in sql server 2008?

948

How do you trace the traffic hitting a sql server?

1147

how can you check the level of fragmentation on a table? : Sql server administration

990

How do I start and stop sql server?

1034

How to call a function from a stored procedure in SQL Server ?

1036

What is instead of trigger sql server?

1012

What is data modification?

982

What is the purpose of linked server configuration in sql server?

1055

Your table has a large character field there are queries that use this field in their search clause what should you do?

887

What are different types of statements that are supported by sql?

1050

What is the recursive stored procedure in sql server?

1029

How to Sync Two SQL Azure Databases?

121

What is the difference between web edition and business edition?

111

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1053

What is 1nf normalization form?

1043