simple max function query

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 - 18:22:55 CDT