Dear gurus,
I have a table like this
id counter text
001 001 AAA
001 002 BBB
002 001 AAA
002 002 BBB
002 003 CCC
I want to have a o/p like this
001 002 BBB
002 003 CCC
it it should fetch the latest counter of the id text
please help me out regards this query
thank in advance
Senthil