Hello SAP Experts, Can anyone tell me that when to use subquery or joins in oracle (why we use subquery instead of join)? If anyone from you guys will solve my query then it would be really nice for me to work accordingly.
Thank You in Advance!
Level in Subquery in Join Condition
Hi, I am using the following to specify the date filter for my query. of the last full week (Sun-Sat) using the following : WHERE CAST(DATECOL AS DATE) BETWEEN (SELECT TO_DATE(TO_CHAR(A.dy...
What is the purpose of using a subquery?
Q. A subquery can be used to _________. A. create groups of data B. sort data in a specific order C. convert data to a different format D. retrieve data based on an unknown condition ...