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 to define testing of network layers? : Sql server database administration

954

---

How to get nth highest salary from employee table.

1149

---

What do you understand by SQL*Net?

997

---

What is the purpose of grouping data in a report?

942

---

What are xml indexes?

925

---

What are sp_configure commands and set commands?

1003

---

Define outer join in sql server joins?

922

---

How do you delete a trigger?

955

---

Do you know the policy based administration feature of sql server 2008?

936

---

Which trace flags are enabled in sql server?

989

---

Explain about Normalization?

1040

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3856

---

explain the storage models of olap? : Sql server database administration

937

---

Can sql servers link to other servers like oracle?

827

---

Explain how to maintain a fill factor in existing indexes?

979

---