select * table1
where f1='aaaaaa'
and f2='ffff'
and f3 in (
select max(f3) as f3
from table1
where f1='aaaaaa'
and f2='ffff'
)
where f1='aaaaaa'
and f2='ffff'
and f3 in (
select max(f3) as f3
from table1
where f1='aaaaaa'
and f2='ffff'
)
where f1='aaaaaa'
and f2='ffff'
--and f3 in(
and f3 =(
select max(f3) as f3
from table1
where f1='aaaaaa'
and f2='ffff'
)