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

What does select 1 mean?

925

---

Can we insert data into a view?

1136

---

What is 1nf normalization form?

1034

---

Explain the cursor lock types?

1051

---

What are the different types of cursor?

1096

---

explain different levels of normalization? : Sql server database administration

1003

---

How to check parameter value in stored procedure sql server?

972

---

How to fetch the next row from a cursor with a "fetch" statement?

1073

---

Does full backup break log chain?

962

---

What is a constant or literal in ms sql server?

1045

---

Define views.

1012

---

What is clustered vs nonclustered index?

946

---

How many full-text indexes can a table have?

974

---

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

881

---

How many types of triggers are there?

1064

---