with tmp(ID,tvalue1,date,seqno) as (values
('A','3534','20060113',1),
('A','3521','20060113',2),
('A','3531','20060113',3),
('B','3123','20060112',1),
('B','3456','20060112',2),
('B','3688','20060112',3))

select ID,tvalue1,date,seqno
from
(select a.*,ROW_NUMBER() over(partition by id order by date desc,seqno desc) drk
  from tmp a
) a
where drk=1;

 select id, max(value1) value1, max(date) date, max(seqno) seqno 
 from table
 group by id;