select
a.ID , a.Date , a.CustomerID , a.Checks
from ordertb a
where not exists(select 1 from ordertb where ID = a.id and Checks > a.Checks)
a.ID , a.Date , a.CustomerID , a.Checks
from ordertb a
where not exists(select 1 from ordertb where ID = a.id and Checks > a.Checks)
from ordertb a,
(
select ID ,max(Checks) as Checks
from ordertb
group by ID
) b
where a.ID = b.ID and a.Checks= b.Checks
from (
select ID ,max(Checks) as Checks
from ordertb
group by ID
) a
left outer join ordertb b on where a.ID = b.ID and a.Checks= b.Checks