Answer Posted / chiru

select distinct sal from emp e where 2=(select
count(distinct sal) from emp where e1.sal>e.sal) order by
sal desc;

What is the difference between left outer join and left join?

993

---

what is the difference between delete and truncate statement in sql? : Sql dba

1244

---

Mention what is the use of function "module procedure" in pl/sql?

1049

---

Which join is like inner join?

1027

---

Is sql a scripting language?

1004

---

Show the two pl/sql cursor exceptions.

1194

---

Define implicit and explicit cursors.

1144

---

how can we submit a form without a submit button? : Sql dba

985

---

What does cursor do in sql?

1018

---

Mention what are the benefits of pl/sql packages?

1080

---

Can you selectively load only those records that you need? : aql loader

1048

---

Why does sql need a server?

1038

---

what is transaction? : Sql dba

1007

---

What are the ways on commenting in a pl/sql code?

1133

---

What is an oracle stored procedure?

1050

---