Ignore Duplicte Entries in count 1

[johnv20]

Hi, I have a table that looks something like

Name Info
AAA BBB
AAA CCC
DDD BBB
AAA CCC

How do I count the total no. of entries in the table only ignoring those entries where both fields are duplicates of a previous one. So that the answer to the table above would be 3?

 

[tlbroadbent]

Select Name, Info, Count(*) As DistinctCnt
From
(Select Name, Info From Table
Group By Name, Info)
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.