How do I write SQL

Posted in 1997

rich — Mon, 10 Feb 1997 13:54:15 -0500 — source: Informix-list mailing list archive (1991-1998)

How do I write SQL to perform the following: I have a table that contains prices for five years. I need to select the last price posted in each month. The record format is key,date,value -- the data in any one month could be one record or up to twenty records. I need the output to show the date and value. Thanks Rich Newell richn@northv.com