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

What is the security principal at the database level that represents your session?

907

---

explain different types of constraints? : Sql server database administration

929

---

How would we use distinct statement? What is its use?

1037

---

Does sql server use java?

1014

---

What is replication with database mirroring? : sql server database administration

1006

---

What are the advantages dts has over bcp?

957

---

Give a example to search fr a string in all stored procedure in sql server.

925

---

What is the security principal at the server level that represents your session?

978

---

What is the significance of master, tempdb and model databases?

1040

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

901

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1066

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

996

---

Write a program to fetch first 10 records from a file?

978

---

what are the three command line utilities and what are their primary functions?

140

---

What does this statement do @@rowcount?

935

---