How to retrieve three coloumns from a table!!!!!

[Shestakov]

Try this:

select * from TBL
where type='UPDATE' and
ubdate = (select max(update) from tbl)
union
select * from TBL
where type='PREVIEW' and
preview = (select max(preview) from tbl)
union
select * from TBL
where type='LIVE' and
live = (select max(live) from tbl)
;