SESSION NAME: Joins and Unions-2.
QUESTION NAME: Unions All of Count Table.
TABLE DESCRIPTION:
Write a Query to Join the following tables and find the
number of rows in the table using count function
Table 1 = items_ordered
Table 2 = submissions
Hint: Use Count Function and Union All to add both the
tables
number of rows in the table using count function
Table 1 = items_ordered
Table 2 = submissions
Hint: Use Count Function and Union All to add both the
tables
CODE:
select count(*) from items_ordered Union All select count(*) from submissions;
0 Comments