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 is a field in a database ? : Sql dba

991

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

---

what does the t-sql command ident_current does? : Transact sql

931

---

What is the difference between the conventional and direct path loads? : aql loader

1317

---

explain what is mysql? : Sql dba

1032

---

What is error ora-01000: maximum open cursors exceeded

1065

---

How do you change a value in sql?

968

---

What is the difference between an inner join and an outer join?

971

---

Why do we use procedures?

914

---

what is heap table? : Sql dba

1049

---

What is an ndf file?

927

---

How many primary keys can a table have?

955

---

Explain the the delete statements in sql?

982

---

define sql update statement ? : Sql dba

1051

---

How do sql databases work?

947

---