Re: SQL Question

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Fri, 4 Oct 2002 10:02:05 -0700
Message-ID: <ankhg7$2pq$1_at_spiney.sierra.com>


select * from
(
 <insert your query here>
 )
where rownum = 1

"Gigi Lipori" <pflugg_at_bellsouth.net> wrote in message news:3d9dbe89$1_4_at_corp-news.newsgroups.com...
> I have the SQL, below. I actually only want to return the first value for
> each group, though. How can I change my SQL to accomplish that? Basically,
> for each pat_id, patient_labs_column_name, I want the most recent date
 with
> its associated result. Truly appreciate any help! Gigi
>
> SELECT
>
> PAT_ID,
>
> MAX(PATIENT_LABS_COLUMN_NAME) AS LAB_TYPE,
>
> MAX(DATE_OF_LAB) AS MR_DATE,
>
> MAX(MISC_LAB_VALUE) AS RESULT
>
> FROM
>
> MISC_LABS,
>
> MISC_LABS_CODES
>
> WHERE
>
> (MISC_LABS.MISC_LAB_CODE_ID = MISC_LABS_CODES.MISC_LAB_CODE_ID)
>
> AND (MISC_LABS_CODES.PATIENT_LABS_COLUMN_NAME IS NOT NULL)
>
> AND (PAT_ID = 13964)
>
> GROUP BY
>
> PAT_ID,
>
> PATIENT_LABS_COLUMN_NAME,
>
> DATE_OF_LAB
>
> ORDER BY
>
> PAT_ID,
>
> PATIENT_LABS_COLUMN_NAME,
>
> DATE_OF_LAB DESC
>
>
>
Received on Fri Oct 04 2002 - 19:02:05 CEST

Original text of this message