using having and max function
Hi ,
when i ran this query :
select description_level1 , description_level2 , end_time , loading_timestamp from time_logging
where description_level2 = 'Chrt2D' and
description_level1 = 'FAB2_Inline2D'
group by loading_timestamp , description_level1 , description_level2 , end_time
having max(loading_timestamp) ;
i got this error :
ORA-00920: invalid relational operator
which i dun understand but i could run this query though --> select max(loading_timestamp) from time_logging ;
pls advise
tks & rdgs