Re: SQL Tip

["Steve Landess" <sjl_abc@xxxxxxxxxxx>]

Jeffrey -

I don't disagree about the power of common table expressions, but I think 
you could have probably given a better example, since the example you gave 
doesn't require an intermediate table.

Ignoring the syntax error in your example (you left out the "from Batch_Sum" 
clause in the
second SELECT statement), your example of using a CTE was:

> With Batch_Sum as (Select Batch#,Div2 from OrsBatch group by batch#,
> div2) Select Batch#,Div2 from Batch_Sum group by Batch#,Div2 having
> count(*) > 1

Doesn't the SQL statement below produce the same results as the one above?

Select Batch#, Div2, count(*) from OrsBatch
group by batch#, div2
having count(*) > 1

(I would probably also add an "order by Batch#, Div2" to the end of the 
statement to order the results)

Regards,
Steve