Answer Posted / ajay roy

The Correct answer is ---

select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)

Thanks Elumalai.k

Top Keyword returns the top(first) row not the max record

Define full outer join in sql server joins?

912

---

How many joins in sql server?

897

---

Can the “if update (colname)” statement be used in a delete trigger?

943

---

Can you explain important index characteristics?

935

---

What is the latest version of microsoft sql server?

960

---

What is open database communication (odbc)?

1003

---

How the authentication mode can be changed?

1074

---

What is sub query and its properties?

916

---

what is the different types of backups available in sql server? : Sql server database administration

879

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1115

---

What is the ‘fillfactor’?

914

---

Difference between connected and disconnected database in .net with sql server?

1033

---

What is transaction server explicit transaction?

968

---

What is “asynchronous” communication in sql server service broker?

958

---

Explain what role entity and relationship play in an ER diagram.

1016

---