there is table suppose temp table, in this table there are 2 colume i.e name and value
there are record like:
name value
a 10
a 20
a 30
b 15
b 17
c 10
Now I need resultant table
like
name value
a 30
a 20
b 17
b 15
kindly solve this query ltl bit urgent...
Thanks