SQL-doubt

Question

1. Can WHERE clause be used with aggregate functions ?

2. DISTINCT operates on a single column. DISTINCT for multiple columns is not supported. [T/F]

Comments

1. http://stackoverflow.com/questions/6319183/aggregate-function-in-sql-where-clause

2.http://stackoverflow.com/questions/54418/how-do-i-or-can-i-select-distinct-on-multiple-columns

Answer 1

1. its true but only if we are using it in subqueries.

2. False because if u want distinct columns then u should use in group by clause rather using distinct.

Comments

• SELECT DISTINCT returns only distinct (different) values.
• SELECT DISTINCT eliminates duplicate records from the results.
• DISTINCT can be used with aggregates: COUNT, AVG, MAX, etc.
• DISTINCT operates on a single column. DISTINCT for multiple columns is not supported.

http://www.dofactory.com/sql/select-distinct

---

Answer  edited.. sorry i had misunderstood the concept...