SELECT * FROM mytable ; WHERE Grpid + Grpver IN ( ; SELECT MAX(Grpid + Grpver) FROM mytable GROUP BY ref)>Don't know if this can be done, but here goes. Given the below structure and example data:
>Grpid Grpver Ref Len Descriptio > >ODDE 1 POLNO 25 Policy Number >ODDE 2 POLNO 25 Policy Number >ODDE 3 POLNO 25 Policy Number >ODDT DDCDL 3 Code Length >ODDT 1 DDCDL 3 Code Length >ODDT 2 DDCDL 4 Code Length >6SBC CANCL 2 Cancel Days >6SBC 1 CANCL 2 Cancel Days >6SBC 2 CANCL 3 Cancel Days >>I want to select distinct records for the ref field but I always want the highest Grpid+Grpver value. So in the above example the query result would be 3 records:
>ODDE 3 POLNO 25 Policy Number >ODDT 2 DDCDL 4 Code Length >6SBC 2 CANCL 3 Cancel Days >>Because ODDE 3 and ODDT 2 and 6SBC 2 are the highest grpver's for each grpid. Can this be done?