Answer Posted / divya

Select Salary
From Employee
Where rowid = n
Order By Salary Desc;

How to define output parameters in stored procedures?

539

---

Define self join?

639

---

What is difference between cte and view?

532

---

What are click through reports?

101

---

what is an extended stored procedure? : Sql server database administration

513

---

---

What are “unrepeatable reads”?

755

---

What is the difference between commit and rollback?

515

---

What is difference between join and natural join?

485

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

604

---

Can we store videos inside the sql server table?

531

---

Can a table be moved to different filegroup?

582

---

What is data source document?

554

---

Distinguish between nested subquery and correlated subquery?

560

---

What is partition, how will you implement it? : sql server analysis services, ssas

615

---

What is sleeping status in sql server?

535

---