this is my table
Value | status | Max_date | clm_no | Current_date | Differnce | clm_num |
- | Not Outlier | 04-Jan-2016 | RC-HS15-10325506-1 | 18/07/2016 | 197 | - |
1.000 | Outlier | 30-Nov-2015 | RC-HS15-10325506 | 18/07/2016 | 232 | - |
1.000 | Outlier | 24-Dec-2015 | RC-HS15-10329647 | 18/07/2016 | 208 | - |
1.000 | Outlier | 06-Dec-2015 | RC-HS15-10326507 | 18/07/2016 | 226 | - |
- | Not Outlier | 26-Jan-2016 | RC-HS15-10325506-2 | 18/07/2016 | 175 | - |
0.000 | Not Outlier | 01-May-2016 | RC-HS16-10349544 | 18/07/2016 | 79 | - |
- | Not Outlier | 31-May-2016 | RC-HS16-10349544-1 | 18/07/2016 | 49 | - |
1.250 | Outlier | 31-May-2016 | RC-HS16-10349544-1 | 18/07/2016 | 49 | - |
in this i want highest max date along with its clm_no but i dont want its supplementary clm no
above table giving me right but it showing me with supplementary clm_no that i dont wnt so it should give
Value | status | Max_date | clm_no | Current_date | Differnce | clm_num |
- | Not Outlier | 04-Jan-2016 | RC-HS15-10325506-1 | 18/07/2016 | 197 | - |
1.000 | Outlier | 30-Nov-2015 | RC-HS15-10325506 | 18/07/2016 | 232 | - |
1.000 | Outlier | 24-Dec-2015 | RC-HS15-10329647 | 18/07/2016 | 208 | - |
1.000 | Outlier | 06-Dec-2015 | RC-HS15-10326507 | 18/07/2016 | 226 | - |
- | Not Outlier | 26-Jan-2016 | RC-HS15-10325506-2 | 18/07/2016 | 175 | - |
0.000 | Not Outlier | 01-May-2016 | RC-HS16-10349544 | 18/07/2016 | 79 | - |
- | Not Outlier | 31-May-2016 | RC-HS16-10349544-1 | 18/07/2016 | 49 | - |
1.250 | Outlier | 01-May-2016 | RC-HS16-10349544 | 18/07/2016 | 49 | - |
so can any on help me in this