SQL Server Performance Forum – Threads Archive
SQL Query Execution planHi, 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
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.