Answer Posted / divya c

Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));

What are the various levels of constraints?

666

---

What is sql not null constraint?

605

---

What is the purpose of cursors in pl/sql?

638

---

What is a recursive stored procedure?

621

---

What is Histogram?

1103

---

---

Is it possible to create the following trigger: before or after update trigger for each row?

722

---

Why do we use joins?

568

---

How can I speed up sql query?

527

---

What is the difference between sum and count in sql?

528

---

What are records give examples?

566

---

what is sp_pkeys? : Transact sql

699

---

explain commit and rollback in mysql : sql dba

547

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

548

---

When sql appeared?

623

---

Which certification is best for sql?

542

---