Hi there, I need to do the following in one SQL query:
select field1, field2, field3, field4, field5 from table where field6 < 5 order by field1 And a totals line which shows the sum for each column. The important part is that I need to preserve the order by of the first query. Is there any way to do this in one query? Thank you, -- Casey Allen Shobe, Open Source Software Solutions [EMAIL PROTECTED] / http://www.osss.net / 770-653-4526 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
