-----Original Message-----
From:	Jim Finerfrock [mailto:jfinerfrock@geocomm.com]
Sent:	Wednesday, September 30, 1998 6:54 PM
To:	Ari Kaplan
Subject:	SQL Question

Ari,

How would one return the row with the max total (see below example)?


ID        FISCALYR TYPE   TOTAL
2132901       1999    3   2488569
2132901       2003    5  92068040

Thanks,
Jim

----- Reply --------------------------
SELECT ID, FISCALYR, TYPE, TOTAL
FROM table_name
WHERE TOTAL IN (SELECT MAX(TOTAL)  FROM table_name)
/

Regards,

-Ari Kaplan
www.arikaplan.com

Back to Ari Kaplan's Home Page i Kaplan's Home Page