Answer Posted / sandeep

select top(1) a.name
from

(
select top(2) name,salary
from
employee
order by salary desc
)a
order by a.salary asc

Is sql an operating system?

1023

---

How to get each name only once from an employee table?

1120

---

what is the difference between nested subquery and correlated subquery?

1060

---

What is the least restrictive isolation level? : Transact sql

1079

---

List the various privileges that a user can grant to another user?

1047

---

What are sql indexes?

1005

---

What is the difference between count 1 and count (*) in a sql query?

1001

---

Which version of sql do I have?

1068

---

differentiate between float and double. : Sql dba

1065

---

What is prepared statement in sql?

1060

---

What port does sql server use?

1070

---

What are aggregate functions in sql?

1169

---

How do I trace sql profiler?

995

---

What is a database event trigger?

1165

---

define join and explain different type of joins? : Sql dba

957

---