example:

SELECT OPB_MAPPING_N.MAPPING_NAME as MAPPING_NAME ,max(VERSION_NUMBER) as VERSION_NUMBER FROM OPB_MAPPING_N WHERE MAPPING_NAME like '%search%'
GROUP BY OPB_MAPPING_N.MAPPING_NAME


here "search" is a column name.

please help me regarding this.