FWIW...

SELECT *
FROM _table_ t
where RecordCount in (
select MAX(RecordCount)
FROM _table_ t1
GROUP BY CardNumber, CompanyID) as t2

HTH

Steve

=======================================
Everyone here speaks SQL; some are more fluent, others less. When
describing your SQL object (table, etc.), do so in the language that we
all understand - SQL, not English. It makes it easier to understand
your issue and makes it more likely that you will get the assistance
that you are asking for.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!