By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Select groupping by one column

P: n/a
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

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


--
Josué Maldonado

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, Dec 18, 2003 at 15:09:52 -0800,
Josué Maldonado <jo***@lamundial.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.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

P: n/a
Hello Bruno,

Bruno Wolff III wrote:

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.


I missed the group by 1, I'm sorry.

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.


Thanks

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.