Answer Posted / manjusha

select * from emp e1
where 2=(select count(distinct salary) from emp e2
where e1.sal<e2.sal);

what is a stored procedure? : Sql dba

1054

---

how do you know if your mysql server is alive? : Sql dba

1027

---

What is the life of an sql statement?

964

---

Why use stored procedures?

1020

---

what is difference between delete and truncate commands? : Sql dba

1067

---

What is t sql in sql server?

1003

---

What is sql profiler in oracle?

1015

---

What is the basic form of sql query?

881

---

How do I find duplicates in a single column in sql?

954

---

what is the difference difference between procedure and packages

10251

---

Which software is used for pl sql programming?

931

---

what is the functionality of the function htmlentities? : Sql dba

894

---

Can we insert in sql function?

1027

---

What are schema-level triggers?

1047

---

What is sql query optimization?

1023

---