Just a heads up p.amount > all (...subquery...) ye wala better rehta. Apne course m dikkat nhi deta but online khi questions kre to kaafi time error deta.
@@xytan3502 accha ,, thanks,,hn iss query to time complexity jyada lgega hi .. Ous time PDSA nhi odha tha n to thoda km gyan tha time complexity ka so 😅
@@ashishmaurya7157 tc hi wjh se nhi actually working m subtle difference h.. all waala, in case if, the subquery returns multiple values, it checks whether p.amount is greater than every one of those values. While dusra wala if, the subquery returns multiple values, it only needs to find one value for which p.amount is greater.
Just a heads up
p.amount > all (...subquery...) ye wala better rehta. Apne course m dikkat nhi deta but online khi questions kre to kaafi time error deta.
@@xytan3502 accha ,, thanks,,hn iss query to time complexity jyada lgega hi ..
Ous time PDSA nhi odha tha n to thoda km gyan tha time complexity ka so 😅
@@ashishmaurya7157 tc hi wjh se nhi actually working m subtle difference h.. all waala, in case if, the subquery returns multiple values, it checks whether p.amount is greater than every one of those values. While dusra wala if, the subquery returns multiple values, it only needs to find one value for which p.amount is greater.
@@xytan3502 okk got it sir,, thanku so much
@@ashishmaurya7157 arre 😅🫶💙