怎么取重复字段中最大值,比如只要取busy_count_glc字段中重复数据的一条数据
11785 9156 2012102317
SQL> select busy_count_glc,busy_succ_glc,busy_hour_glc from DAY_KPI where KPIDAY=to_date('20121023','yyyymmdd') ;
BUSY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
BUSY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
BUSY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
BUSY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
8649 7983 2012102316
3961 3936 2012102300
1941 0 2012102315
11785 9156 2012102317
排序下来
USY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
BUSY_COUNT_GLC BUSY_SUCC_GLC BUSY_HOUR_
-------------- ------------- ----------
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
11785 9156 2012102317
8649 7983 2012102316
8649 7983 2012102316
8649 7983 2012102316
8649 7983 2012102316