Re: SQL question
From: Ray Chance <rchance_at_netcom.com>
Date: Sat, 6 Nov 1993 17:35:22 GMT
Message-ID: <rchanceCG2zIz.At7_at_netcom.com>
Date: Sat, 6 Nov 1993 17:35:22 GMT
Message-ID: <rchanceCG2zIz.At7_at_netcom.com>
Gary R. Kephart (kephartg_at_ema.rockwell.com) wrote:
: Suppose I have a table with a key field (FIELD_A) an integer field (FIELD_B)
: and a bunch of other fields. How can I get the maximum FIELD_B and its FIELD_A
: value using one query?
try... select field_a,field_b
from xx
where field_b = (select max(field_b)
from xx)
Received on Sat Nov 06 1993 - 18:35:22 CET