Answer Posted / satish

select max(sal) from emp e1 where 1< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

To make it generic if u want N'th highest salary;

select max(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

And to get the N'th min sal :

select min(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal >= e2.sal)

Which tcp/ip port does the sql server run on? How can it be changed?

990

---

How we can compare two database data?

870

---

What is ssl in sql server?

1010

---

When we should use and scope of @@identity?

951

---

What are “lost updates”?

948

---

What are 3 ways to get a count of the number of records in a table?

1015

---

What is BLOCK statements in SQL?

1205

---

What is reportserver and reportservertempdb ?

140

---

How do I know if localdb is running?

890

---

How to convert a unicode strings to non-unicode strings?

1026

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

949

---

What do you need to connect php to sql server?

1034

---

How to turn on the mssql api module in php?

1010

---

What are subquery and its properties?

979

---

What is the standby server?

908

---