Answer Posted / kaushal kassi

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

How to prepare for oracle pl sql certification?

577

---

What is information schema in sql?

586

---

What is mdb stand for?

560

---

What is a data definition language?

560

---

Is ms sql is free?

536

---

---

What is restrict in sql?

561

---

Does truncate free space?

523

---

What is the maximum database size for sql express?

541

---

Does oracle roll back the transaction on an error?

541

---

How many joins can you have in sql?

531

---

Write an sql query to select all records from the table?

563

---

What is before and after trigger?

524

---

Which is the correct statement about truncate and delete?

534

---

What is the difference between microsoft access and sql server?

536

---

What is %type in sql?

522

---