Oracle sql fiding shipping delay -
can know how write sql statement in listing shipping city , state order has longest shipping delay. not sure need use function max in where i'm assuming data structure flat, in: create table orders ( ... shipping_city varchar2(100), shipping_state varchar2(100), shipping_delay number(7), ... ); you can write: select max(shipping_city) keep (dense_rank last order shipping_delay), max(shipping_state) keep (dense_rank last order shipping_delay) orders