Re: simple max function query

that should be possible; you may just need to change your group by clause to match your NON-calc'd field, eg, the MAX

select tar_status_tar
 ,max( tar_status_number) "max"
 ,tar_status_status
 from tar_status
 where tar_status_tar = '106988'
 group by tar_status_status
  ,tar_status_tar

• as is, you are grouping by the value that you want to max, each time it changes, voila, max.

brent

john bruin wrote in message <37C1D7CF.255C_at_tssc.co.nz>...
>Can someone show me how to get the last value in a column.
>I thought the max function would do it but it just shows all the values
>whereas I only want the last row value.
>
>select tar_status_tar
> ,max( tar_status_number) "max"
> ,tar_status_status
>from tar_status
>where tar_status_tar = '106988'
>group by tar_status_status
> ,tar_status_tar
> ,tar_status_number
>
>
>Thanks in advance.
>John
Received on Tue Aug 24 1999 - 09:49:28 CDT