Tells SQL to use all the column results from the intermediate result table (namely, all the columns in all the table references referred to in the FROM clause). If the select expression contains a GROUP BY clause, SQL interprets the wildcard (*) as specifying only the expressions in the GROUP BY clause.