Re: Select groupping by one column

On Thu, Dec 18, 2003 at 15:09:52 -0800,
Josué Maldonado <josue(at)lamundial(dot)hn> wrote:
> Hello list,
>
> I have a table called pedh that looks like this:
>
> REFNO FECHA OCNUM PVD
> 0199 10/12/2003 5224 632
> 0199 10/12/2003 5224 632
> 1264 10/18/2003 8991 210
> 1264 10/18/2003 8991 210
> 1264 10/18/2003 8991 210
> 9093 10/20/2003 6895 520
> 9093 10/20/2003 6895 520
>
> I need to select one record groupped by column refno, I tried using this
> code:
>
> select refno, max(fecha), max(ocnum), max(pvd) from pedh

I don't see how that could work. Maybe you left off group by. But if you
did the aggreates could come from different rows, which might not be what
you want.

>
> It seems to work fine, but is there another way to get the same result
> avoing use of aggregate functions?

You might be able to use distinct on instead of aggregates.