Answer Posted / srikanth

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

What is the maximum number of columns in sql table?

541

---

What are triggers and its uses?

587

---

What is the difference between a primary key and a unique key?

552

---

How to execute a stored procedure?

553

---

What is a behavioral trigger?

510

---

---

What is java sql drivermanager?

539

---

What will you get by the cursor attribute sql%rowcount?

545

---

How do I count duplicates in sql?

539

---

Can a primary key be a foreign key?

568

---

What is procedure function?

526

---

Is subquery faster than join?

563

---

Why is sql important?

575

---

how to add a new column to an existing table in mysql? : Sql dba

576

---

Does asenumerable execute the query?

591

---

Why do we use procedures?

506

---