Answer Posted / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

What is the difference between an inner join and an outer join?

516

---

What do you know by pl/sql cursors?

570

---

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

536

---

What are the most important ddl statements in sql?

577

---

how to check server status with 'mysqladmin'? : Sql dba

571

---

---

what is acid property in database? : Sql dba

561

---

Cite the differences between execution of triggers and stored procedures?

624

---

Is sql easier than java?

527

---

Which sql statement is used to return only different values?

506

---

what is a join? : Sql dba

565

---

What are the ddl commands?

537

---

How do I remove duplicates in two columns?

510

---

What does select * from mean in sql?

1994

---

How does a self join work?

520

---

What is a record in a database?

563

---