Re: simple max function query

max - returns largest value in the field.

select * from table
where rowid = (select max(rowid) from same_table)

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 Mon Aug 23 1999 - 20:33:18 CDT