Question: SQL: 1 ) . You can write 'having' without using group by ? a ) true b ) false 2 ) . If you join

SQL:
1).You can write 'having' without using group by? a) true b) false
2). If you join 2 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
3). SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name
a) true b) false
4) What is the difference between Group by and Having
a).Get
b).Select
c).Extract
5). SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name
a) true b) false

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!