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

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -