finding the max

[SSG001]

I have a table as follows

code
PB0001AA
PB0001AB
PB0001AC
PX0001AA
PX0001AB
PX0001AC
PX0001AD
PC0001AA
PC0001AB


I want to get data of only max
eg in the above case
PB0001AC
PX0001AD
PC0001AB







Thanks in advance

[SSG001]

SELECT MAX(code) FROM exmaster WHERE code IN (SELECT code FROM exmaster) GROUP BY SUBSTRING(code,1,6)

is this ok ?

[SSG001]

SELECT MAX(code) FROM exmaster WHERE GROUP BY SUBSTRING(code,1,6)

[vijay6]

Hey SSG001, you can use like this,

select MAX(Name) from Table_1 where Name like 'PB0001A%' union select MAX(Name) from Table_1 where Name like 'PX0001A%' union select MAX(Name) from Table_1 where Name like 'PC0001A%'

[Rabbit]

Please use code tags when posting code.

You can do this:

SELECT MAX(code)
FROM exmaster
GROUP BY SUBSTRING(code,1,6)