Answer Posted / a.jyothsna

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

How to read/write files from pl/sql?

582

---

What is oracle sql called?

506

---

Can pl sql procedure have a return statement?

552

---

Which data type is a composite type?

534

---

Is it possible to sort a column using a column alias?

609

---

---

What is sql partition function?

620

---

What is user defined functions?

580

---

Is sql pronounced sequel or sql?

746

---

What are the types of views in sql?

543

---

What is normalisation and its types?

550

---

What does sign mean sql?

573

---

how would you enter characters as hex numbers? : Sql dba

518

---

Do ddl statements need commit?

540

---

describe mysql connection using mysql binary. : Sql dba

552

---

what are different types of collation sensitivity? : Sql dba

561

---