SELECT "date" FROM "table" WHERE "color" = 'red' ORDER BY "date" DESC LIMIT 1; Don't worry about names, just quote your identifiers. They will stand out and you can use anything you want. Jerry "Michael Glaesemann" <grzm@xxxxxxxxxxxxx> wrote in message news:89C8EF0C-3447-11D9-8FE6-000A95C88220@xxxxxxxxxxxxxxxx > Scott, > > On Nov 12, 2004, at 10:00 AM, Scott Frankel wrote: > >> color | date >> --------+------------ >> red | 2004-01-19 >> blue | 2004-05-24 >> red | 2004-04-12 >> blue | 2004-05-24 >> >> >> How do I select the most recent entry for 'red'? >> > > SELECT color, MAX(date) > FROM giventable > WHERE color = 'red' -- omit this line if you'd like to see the latest date > for each color > GROUP BY color; > > OT hint: You might want to take a look at the list of PostgreSQL Keywords > in the documentation and avoid using them (such as date) to help you avoid > naming issues in the future. > > Hope this helps. > > Michael Glaesemann > grzm myrealbox com > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
