Answer Posted / nitin munjani

Using Row_Number() function

Here N refers the Nth highest salary

select empid,empname from mstemployee where empsalary in (
(select empsalary from
(select Row_Number() over(order by empsalary desc)
rownm,empsalary from mstemployee
group by empsalary) o where rownm=N))

What is self contained sub query?

1124

---

How to find the source of a table in sql server?

1039

---

How to turn off warning messages during php execution?

1110

---

What are indexers?

1134

---

What is a db view?

951

---

How to get all stored procedures in sql server?

1063

---

What are the dmvs?

1074

---

What is the Main Difference between ACCESS and SQL SERVER?

1190

---

How to verify a user name with sqlcmd tool?

1122

---

Describe in brief system database.

1076

---

Is sql server 2016 free?

983

---

How to use old values to define new values in update statements in ms sql server?

1337

---

What do you understand by user-defined function in the sql server?

1011

---

How to download and install microsoft .net framework version 2.0?

1185

---

What is the current pricing model of SQL Azure?

104

---