Answer Posted / cpnagar

SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3

What is the correct order of the logical query processing phases?

533

---

What is a heap?

627

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

550

---

What is normalization 1nf 2nf 3nf?

641

---

Explain what is lock escalation and what is its purpose?

516

---

---

What is database isolation in sql server? : sql server database administration

572

---

What is the difference between rank and dense_rank?

515

---

Explain different types of self contained sub query?

552

---

What is set nocount on and what is set nocount off?

522

---

What are the kinds of subquery?

539

---

Distinguish between commit and rollback?

560

---

Can foreign key be deleted?

534

---

What is blocking and how would you troubleshoot it? : sql server database administration

602

---

What is inline variable assignment?

618

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

609

---