Answer Posted / ayyappanramachandran

You can achieve this by using following Query

select * from(select top 3 * from employees where
employeeid in(select top 7 employeeid from employees where
employeeid not in(select top 4 employeeid from employees
order by employeeid)))e order by employeeid.

Thanks
AyyappanRamachandran

How will you know when statistics on a table are obsolete?

1087

---

Does order by actually change the order of the data in the tables or does it just change the output?

1153

---

Explain cursor as data base object?

1048

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1017

---

What is normalization process?

1182

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1042

---

Explain can you implement data mining in ssrs?

161

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

956

---

Can you explain important index characteristics?

997

---

What is use of except clause? How it differs from not in clause?

1024

---

What is xdr?

996

---

How many database files are there in sql server 2000?what are they?

1057

---

Explain subquery and state its properties?

1053

---

What does it mean to invest in the index?

978

---

What are the 2 types of classifications of constraints in the sql server?

1127

---