sql - MIN and MAX Oracle 10g -
i have table sales column , date of sales column, , want select min , max , date of min , max response single max date , single min date, in oracle, don't know how it, idea?
thanks
from explanation looks need below:
1) select sales , date table_name sales = ( select min(sales) table_name) 2) select sales , date table_name sales = ( select max(sales) table_name)
in single query
select sales , date table_name sales = ( select min(sales) table_name) union select sales , date table_name sales = ( select max(sales) table_name)
Comments
Post a Comment