Answer Posted / vikram kumar

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

How much does a sql dba make? : SQL DBA

512

---

What does pl sql stand for?

657

---

What is lookup table in sql?

605

---

what is the difference between clustered and non clustered index in sql? : Sql dba

551

---

explain the advantages and disadvantages of stored procedure? : Sql dba

533

---

---

what are different types of keys in sql?

608

---

What is a parameter query?

626

---

What is application trigger?

541

---

How can triggers be used for the table auditing?

594

---

What is pl sql code?

593

---

How many clustered indexes can be created on a table?

595

---

What information is needed to connect sql*plus an oracle server?

589

---

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

595

---

How is data stored on a disk?

543

---

Is join same as left join?

533

---