selectbookmark_id,scaned_timefrom(
selectms.bookmark_id,ms.scaned_timefrom(
selectrs.bookmark_id,rs.scaned_timefrom(
selectrank()over(partitionbys.bookmark_typeorderbys.scaned_timeasc)asrk,s.bookmark_id,s.scaned_time
fromSNSEC_BMARK_SCANED_BARCODEswheres.customer_id=1769718
)rs
wherers.rk>0)msorderbyms.scaned_timedesc)whererownum=1