2 votes 2 votes 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] Databases sql databases + – thor asked Jan 2, 2017 thor 367 views answer comment Share Follow See 1 comment See all 1 1 comment reply dd commented Jan 2, 2017 reply Follow Share 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 3 votes 3 votes Please log in or register to add a comment.
0 votes 0 votes 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. S Ram answered Jan 2, 2017 • edited Jan 2, 2017 by S Ram S Ram comment Share Follow See all 2 Comments See all 2 2 Comments reply Karthik Akula commented Jan 2, 2017 reply Follow Share 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 0 votes 0 votes S Ram commented Jan 2, 2017 reply Follow Share Answer edited.. sorry i had misunderstood the concept... 0 votes 0 votes Please log in or register to add a comment.