Skip to Content
0
Former Member
Dec 08, 2006 at 09:21 AM

Query

24 Views

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