Computer Science
Which is a join condition contains an equality operator ?
- Equijoins
- Cartesian product
- Both (1) and (2)
- None of the mentioned
Related Questions
The following SQL is which type of join :
SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID FROM CUSTOMER, ORDER- Equi-join
- Natural join
- Outer join
- Cartesian product
Which product is returned in a join query have no join condition ?
- Equijoins
- Cartesian product
- Both (1) and (2)
- None of the mentioned
Fill in the blanks:
To specify condition with a GROUP BY clause, _________ clause is used.
Fill in the blanks:
Only _________ functions are used with GROUP BY.