On Sat, 6 Feb 1999, Jonny Hinojosa wrote:
select * from events
where event_id=(select max(event_id) from events);
That works in my event database.
// SET QUERY_LIMIT TO restricts the number of rows returned. I want to
// determine the largest value in a column. Sorry if my question was unclear,
// I am new to %SQL.
//
// Jonny
//
// -----Original Message-----
// From: Neil Burrows [mailto:[EMAIL PROTECTED]]
// Sent: Saturday, February 06, 1999 1:51 PM
// To: Jonny Hinojosa
// Cc: [EMAIL PROTECTED]
// Subject: RE: [GENERAL] No MAX function
//
//
// Hi,
//
// I believe there is a patch in "contrib" directory that does this, but if you
// have Postgres 6.4 then have a look at the
//
// SET QUERY_LIMIT TO
//
// command.
//
// Regards,
//
// ---[ Neil Burrows ]-----------------------------------------------------
// E-mail: [EMAIL PROTECTED] ** This e-mail was **
// Web : http://www.remo.demon.co.uk/ ** Made in Scotland **
// -------< PGP Key available from http://www.remo.demon.co.uk/pgp/ >--------
//
//
//
// > -----Original Message-----
// > From: [EMAIL PROTECTED]
// > [mailto:[EMAIL PROTECTED]]On Behalf Of Jonny Hinojosa
// > Sent: 06 February 1999 19:13
// > To: PostGreSQL Mailing List
// > Subject: [GENERAL] No MAX function
// >
// >
// > Does anyone have a work around for the lack of a MAX function ? I need to
// > find the last record WHERE a LIKE 'x' AND b LIKE 'y'.
// >
// > Jonny Hinojosa
// > TCA Internet
// > [EMAIL PROTECTED]
// > 409.693.8885
// >
// >
//
//
//
--
Principal Member Technical Staff, beyond.com The world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __
