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 the types of subquery? : Sql dba

592

---

What is denormalization in a database?

593

---

Sql technical questions

779

---

What is data manipulation language?

702

---

Advantages and disadvantages of stored procedure?

583

---

---

What does desc stand for?

593

---

What is sqlcommand?

558

---

What are the sql commands?

613

---

How do I turn a list into a table?

514

---

what is sp_pkeys? : Transact sql

702

---

What is the difference between local and global temporary table?

553

---

How many triggers can be applied to a table?

604

---

Explain the purpose of %type and %rowtype data types?

507

---

How can I delete duplicate rows?

567

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

722

---