Answer Posted / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

What is a group function explain with an example?

936

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1077

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

951

---

Do you know hot add cpu in sql server 2008?

896

---

What are the advantages of mirroring?

934

---

List some case manipulation functions in sql?

965

---

Why variables called the most powerful component of ssis?

1025

---

What do you mean by normalisation?

961

---

How to update values in a table with update statements in ms sql server?

956

---

What is log in sql server?

1075

---

What is the difference between coalesce() & isnull()?

1047

---

What is default port number for sql server 2000?

993

---

What is collation?

1098

---

How network traffic be reduced by using the stored procedure?

1044

---

What is an sql server agent?

994

---