SQL Subqueries Tuning sub query for better performance

SQL Subqueries  Tuning sub query for better performance


Use this query for better query performance:
use only single sub query for SQL WHERE clause
select prod_name from prod_table
where (price,qty)=(select max(price),max(qty) from prod_table);


Instead of this query:
select prod_name from prod_table
where price=(select max(price) from prod_table)
and qty=(select max(qty) from prod_table);