Question: SQL: 1 ) . You can write 'having' without using group by ? a ) true b ) false 2 ) . If you join
SQL:
You can write 'having' without using group by a true b false
If you join or more table you must have a common column in both of the tables in case of left, right and inner join a true b false
SELECT columnnames
FROM table
INNER JOIN table
ON tablecolumnname tablecolumnname
a true b false
What is the difference between Group by and Having
aGet
bSelect
cExtract
SELECT columnnames
FROM table
LEFT JOIN table
ON tablecolumnname tablecolumnname
a true b false
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
