Use of Aggregate Functions (Cont........)
QUERY*
select count(distinct Company_name) from Product;As Show Fig...6.1
Output QUERY*
select company_name, count(*) from product group by company_name;As Show Fig...6.2
Output QUERY*
select MAX(quantity) from Product;As Show Fig...6.3
Output QUERY*
select MIN(quantity) from Product;As Show Fig...6.4
Output
Comments
Post a Comment