Answer Posted / prabhjeet singh sethi

select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4

What is Command line parameters in PLSQL.?

1078

---

How do you trace the traffic hitting a sql server?

1102

---

What is a fan-out query in SQL Azure?

121

---

List the various tools available for performance tuning?

857

---

What type of locking occurs during the snapshot generation? : sql server replication

1290

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

897

---

List all the types of user-defined functions?

1024

---

Explain what are magic tables in sql server?

959

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

927

---

What is history table in sql server?

919

---

What is difference between getdate and sysdatetime in sql server 2008?

1017

---

Explain transaction server auto commit?

1002

---

Are resultset updatable?

907

---

What is sql server profiler?

973

---

How to use copy and concatenate commands in SQL?

1088

---