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

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

902

---

How to specify the collation for a character data type in ms sql server?

1016

---

How do you send email on SQL Server?

1051

---

Do you know what is fill factor and pad index?

996

---

Explain the cursor lock types?

1043

---

Show Practically Sql Server Views are updatable?

1109

---

How do you make a trace?

1011

---

What does it mean to be in union?

926

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1027

---

Name few endpoints exposed by ssrs 2012?

355

---

How to change the ownership of a schema in ms sql server?

1176

---

In what sequence sql statement is processed?

1001

---

What are the different acid properties?

1055

---

Give me any three differences between Truncate and Delete.

1094

---

How will you go about resolving deadlocks?

964

---