On 19 apr, 12:01, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On Apr 19, 10:52 am, eebieee...@hotmail.com wrote:
>
>
> Your requirement says: "I want to select all the values from column1
> one time", but your sample output has two entries for the column1
> value "4". These contradict each other. Which do you actually want to
> see?

You are right, I said it wrong. I only want the values where column2
is maximum , most of the time that gives one value but not all the
time.

--
EeBie