Answer Posted / s n yagneswara babu

TO FIND THE SECOND HIGHEST SAL IN EMP TABLE

select max(sal) from emp where sal not in(select max(sal)
from emp)

TO FIND THE 3RD HIGHEST SAL IN EMP TABLE

select max(sal) from emp where sal not in(select distinct
top 2 sal from emp order by sal desc)

TO FIND THE Nth HIGHEST SAL IN EMP TABLE

select max(sal) from emp where sal not in(select distinct
top N-1 sal from emp order by sal desc)

yagneswara babu
yagnesh_sn@yahoo.co.in

Which table keeps the locking information?

879

---

What are the new features of sql server 2008 r2 reporting service?

193

---

What xml support does the sql server extend?

954

---

Why use sub query in sql server and list out types of sub queries?

935

---

When is the use of update_statistics command?

949

---

How do we know if any query is retrieving a large amount of data or very little data?

916

---

Explain the use of containers in ssis and also their types?

906

---

Do you know what is difference between index seek vs. Index scan?

896

---

Can group by be used without aggregate functions?

855

---

Name few endpoints exposed by ssrs 2012?

343

---

What is relationship? What number of sorts of relationship are there?

1060

---

What is sql server management studio? : sql server management studio

1010

---

What is the maximum size of sql server database?

943

---

Explain “@@rowcount” and “@@error” in sql server?

997

---

What are the components of dbms?

902

---