Answer Posted / radha sri seshu

second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);

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

1024

---

What are the different types of tables in sql?

926

---

what is acid property in database? : Sql dba

959

---

Cite the differences between execution of triggers and stored procedures?

1026

---

difference between anonymous blocks and sub-programs.

1077

---

What is the use of %rowtype?

975

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2134

---

what happens if null values are involved in expressions? : Sql dba

999

---

What can you do with pl sql?

1031

---

What is sql used for?

1060

---

Is join same as left join?

977

---

Can we create table inside stored procedure?

903

---

Can sql function call stored procedure?

955

---

what is the difference between truncate and delete statement? : Transact sql

1012

---

What is the reports view in oracle sql developer?

924

---