What is the output for the following query?
select count(fname),fname from employees ;
Query will produce parser error since select list must contain only aggregate function of the column names which are used in group by or having clauses.
Query will return 6 and all employees fnames.
Query will return only count functions output.
None of the above.
In the select list when the aggregate functions are present, the other columns are are allowed only when the columns are used in group by clause.
Back To Top