Answer Posted / dinesh gupta

4th highest salary

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary desc) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 4

3rd lowest salary

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary ) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 3

Can coalesce return null?

1021

---

If a stored procedure is taking a table data type, how it looks?

6450

---

Is sql server a database?

1003

---

What are the benefits of normalization?

1110

---

What does executeupdate return?

981

---

How to access the deleted record of an event?

1040

---

What is the cartesian product of table?

1011

---

Explain about builtinadministrator?

1061

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1122

---

Can a table be created inside a trigger?

972

---

How can you find out how many rows returned in a cursor?

1031

---

What are the advantages of user-defined functions over stored procedures in sql server?

1047

---

Can a database be shrunk to 0 bytes, if not, why?

1108

---

How to enforce security in sql server? : sql server security

1111

---

How are the unique and primary key constraints different?

1077

---