Answer Posted / ashwini

select top 1 salary from emp where salary in (select top 2
salary from emp order by salary asc) order by salary desc

What is mutating error in pl sql?

1028

---

How do I run a script in sql developer?

955

---

Explain about various levels of constraint.

950

---

What is bind reference and how can it be created?

1025

---

Why do we need view in sql?

991

---

How do I edit a stored procedure?

998

---

What is tuple in sql?

1087

---

How do I find duplicates in sql?

937

---

What is cursor in pl sql with examples?

1036

---

What is output spooling in sql*plus?

1041

---

Can sql function call stored procedure?

1028

---

explain commit and rollback in mysql : sql dba

1025

---

How does postgresql compare to oracle/db2/ms sql server/informix?

1039

---

how to select first 5 records from a table? : Sql dba

982

---

What is null in pl/sql?

1077

---