Answer Posted / vikas kant

---To get 2nd highest salary----

select Top 1 salary from Emp where marks in(select top 2
salary from Emp order by salary desc)

---To get 3rd highest salary----

select Top 1 salary from Emp where marks in(select top 3
salary from Emp order by salary desc)



Regards Vikas Kant

Scalability, Availability, Integration with internet, etc.)?

2886

---

Can we call stored procedure in trigger?

954

---

What are horizontal and vertical scaling?

172

---

How do you delete duplicate records in sql server?

1071

---

What command must you use to include the not null constraint after a table has already been created?

1157

---

What are alternate keys?

988

---

How to make conditional sum in ssrs?

179

---

Do comments need to go in a special place in sql server 2005?

866

---

What is nested transaction?

1106

---

How to count groups returned with the group by clause in ms sql server?

1070

---

Explain different types of self contained sub query?

1057

---

How to maintain a fill factor in existing indexes?

1010

---

What is the use of nvl work?

1009

---

Can I save my report as html, excel or word? : sql server management studio

963

---

which backup strategy you are following at ur company

2149

---