RE: SQL Optimizer Issue

I don't see what DISTINCT buys you as you are already guaranteeing unique
Plan by using GROUP BY.  Loyd's post also included ORDER BY which is nice as
it can list the output from highest count to lowest count, i.e.

SELECT Plan, COUNT(*)
FROM the_file
GROUP BY Plan
ORDER BY 2

Elvis

-----Original Message-----
Subject: RE: SQL Optimizer Issue

I did not realize there was a distinct() function, very handy. In case
anyone else out there is trying to run this, to get the query below to
run I needed to do.

Select distinct(plan), count(*) from the_file
Group by plan

Chris

-----Original Message-----
Subject: RE: SQL Optimizer Issue

Even better: 
Select distinct(plan), count(*) from the_file

Optionally: ... order by 2 desc

Loyd Goodbar