Answer Posted / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

What are different methods to trace the pl/sql code?

544

---

What is the difference between python and sql?

524

---

what are tables and fields? : Sql dba

580

---

What is a loop in sql?

570

---

how to fetch common records from two tables? : Sql dba

633

---

---

Explain autonomous transaction.

636

---

what are the 'mysql' command line options? : Sql dba

557

---

Explain how to use transactions efficiently : transact sql

529

---

What are the most important characteristics of pl/sql?

578

---

What are the various restrictions imposed on view in terms of dml?

523

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

755

---

Why truncate is used in sql?

531

---

Why we use pl sql?

531

---

Explain alias in sql?

583

---

What are types of joins?

536

---