Answer Posted / yogesh

select e2.salary
from emp e1
join emp e2
on e1.salary >= e2.salary
group by e2.salary
having count(e2.salary) = n

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

What command do we use to rename a database?

1116

---

What does indexation mean?

1030

---

What is the difference between implicit and explicit transaction?

1052

---

Do you know the different ddl commands in sql?

1104

---

How to create a simple stored procedure in ms sql server?

1087

---

Explain transaction isolation levels in sql server?

1182

---

Which language is supported by sql server?

1063

---

How do I find the sql server version?

1080

---

How to sort query output in descending order in ms sql server?

985

---

How to provide default values to stored procedure parameters?

1103

---

Explain relational data?

968

---

What do you mean by SQL injection attack?

1125

---

What is the sql server agent?

1145

---

Do comments need to go in a special place in sql server 2005?

911

---