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....!

How do I view tables in sql developer?

960

---

What is the sql case statement?

1018

---

What is record in pl sql?

1094

---

How would you convert date into julian date format?

1010

---

What is the requirement of self-join?

1140

---

How to run pl/sql statements in sql*plus?

1095

---

what is query cache in mysql? : Sql dba

1050

---

How to return multiple rows from the stored procedure?

979

---

What is primary key in db?

1019

---

What is crud stand for?

1007

---

What is embedded sql with example?

1059

---

What does closing a cursor do?

1332

---

Explain the difference in execution of triggers and stored procedures?

1028

---

Why is the cursor important?

1051

---

Is time a data type in sql?

915

---