Can anyone suggest me what's the difference between using set operators and subqueries in sql language? Difference parameters can be functional, performance-wise, compatibility, integration with existing systems and scalability.
Asked
Active
Viewed 305 times
0
-
The two aren't really comparable as they perform different things. You cannot express an `INTERSECT` operation in a subquery or vice-versa. – Dai Sep 06 '15 at 05:38
-
Actually we need to make a feasible report (white paper) upon the usage of set operations VS sub queries in sql language. Can yu please help me..? @Dai – Shyam Sep 06 '15 at 05:42
-
If you agree to my hourly rate, sure :) – Dai Sep 06 '15 at 05:46
-
Hourly rate in the sense..? – Shyam Sep 06 '15 at 05:49