Answer Posted / r.arjunarao

select a.sal from emp a where 2=(select count(distinct(b.sal)) from emp b where b.sal>=a.sal)

How do I start pl sql?

954

---

How many types of triggers are there in pl sql?

1070

---

What has stored procedures in sql?

1070

---

Explain the components of sql?

1068

---

What is the difference between explicit and implicit cursors in oracle?

1071

---

What is data control language (dcl)?

1147

---

how many tables will create when we create table, what are they? : Sql dba

1085

---

How to fix oracle error ora-00942: table or view does not exist

1019

---

Can 2 queries be executed simultaneously in a distributed database system?

1150

---

Which one is better subquery or joins?

1069

---

What is sql dialect?

1125

---

How do you remove duplicates without using distinct in sql?

985

---

What is sql profiler in oracle?

1099

---

What are the topics in pl sql?

978

---

How do I view a view in sql?

956

---