Specifies that only unique rows can appear in the result table.
can be any aggregate function.
specifies any valid SQL expression.
See | <sql-expression> |
FedSQL Expressions |
is a query that retrieves rows from a table.
See | For more information about using the DISTINCT predicate in the SELECT statement, see the SELECT Clause. |
select count(distinct avghigh) from worldtemps;
select distinct c1.employee, firstname, salary from company as c1;