Answer Posted / amit kumar

--- Getting 4th highest salary
--- 4 can be replaced with any number

with EmpSal as
(Select *, row_number() over (order by EmpSal Desc)
as 'rownumber' from employee)

Select * from EmpSal where rownumber =4

What are secondary xml indexes?

1077

---

Can you please explain the difference between function and stored procedure?

1048

---

Difference between aggregate functions of sql?

1149

---

What is isnull() operator?

1092

---

Can an entity have two primary keys?

1031

---

If the job running very slow what is the action you do

1942

---

What does it mean to manipulate data?

1054

---

What are group functions in query statements in ms sql server?

1066

---

What is collation?

1195

---

what is difference between NULL and ISNULL in SQL Server 2008?

1058

---

What is a scheduled job or what is a scheduled task?

1012

---

What happens if you add a new index to large table?

984

---

What are the differences between sql server and mysql.

1146

---

Does order by actually change the order of the data in the tables or does it just change the output?

1208

---

Define compound operators?

972

---