Answer Posted / dinesh

select distinct(a.salary)
from Salarydtls a
where 3= (select distinct(count(b.salary))
from salarydtls b
where a.salary<=b.salary)

ans is for third highest sal

Explain system scalar functions?

1004

---

What are commit and rollback in sql?

1131

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1091

---

When would you use sql joins?

965

---

What stored by the model? : sql server database administration

958

---

What is left outer join in sql server joins?

1045

---

What is a linked server in sql server?

1080

---

Does the order of columns in update statements matter?

916

---

What is cube dimension? : sql server analysis services, ssas

1010

---

What is the command used to check locks in microsoft sql server?

1045

---

In which tcp/ip port does sql server run? Can it be changed?

991

---

What is subquery explain with example?

1066

---

What do you mean by tablesample?

1083

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1194

---

How to configure odbc dsn with different port numbers?

1090

---