Answer Posted / abhay

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


somebody tell me he logic....!

What are the ddl commands?

1012

---

How can we solve sql error: ora-00904: invalid identifier?

1247

---

What is a unique key?

1056

---

How to add, remove, modify users using sql?

1038

---

What does where 1/2 mean in sql?

1078

---

What is the difference between partition and index?

992

---

What is primary key and foreign key?

962

---

List the various privileges that a user can grant to another user?

1043

---

What is sql data?

996

---

How do I write a cron which will run a sql query and mail the results to agroup?

981

---

Is natural join and inner join same?

929

---

What is application trigger?

1001

---

Does pl sql work in mysql?

983

---

What do you understand by pl/sql packages?

1059

---

What is a primary key called that is made up of more than one field?

1351

---