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 regardsAshish
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
Moderator
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>