SQL Query Execution plan | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Query Execution plan

Hi, This is Ashish. Can anybody send me the execution plan with detail working of query below. this query is aimed to get the nth greatest salary value from employee table. "Select sal from employee e where n=(select count(sal) from employee where sal<e.sal);" If this query if wrong then please write correct query along with details of execution plan. Thanks with regards
Pleas, move your post to General DBA Questions forum, because don’t belong to this forum. I’m curioss, you can’t get execution plan with your Query Analyzer? Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Follow as suggested by Luis, using the Query analyzer. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.