Answer Posted / amarjit singh

--display 3rd higest salary in MSSQLSERVER
select max(sal) from emp
where sal <(select max(sal) from emp
where sal <(select max(sal) from emp
))

--By , STUDENT OF IET BHADDAL ENG COLLEGE

What is measure group, measure? : sql server analysis services, ssas

963

---

What can be used instead of trigger?

1099

---

How do you troubleshoot errors in a SQL Server Agent Job?

1009

---

How to list all stored procedures in the current database using ms sql server?

1058

---

What is after dml trigger?

956

---

what's the difference between a primary key and a unique key? : Sql server database administration

894

---

Explain primary key, foreign key and unique key?

936

---

What do you understand by mirroring and mention the advantages of the mirroring?

1008

---

Differentiate between sql temp table vs table variable?

834

---

What does the on update no action do?

965

---

What is checkpoint in sql server?

1062

---

What is index, cluster index and nonclustered index?

930

---

What is the cartesian product of table?

932

---

what are the new features introduced in sql server 2000? : Sql server database administration

873

---

How will you know when statistics on a table are obsolete?

1034

---