[thelist] sql query help

Joshua Olson joshua at waetech.com
Fri May 24 12:08:10 CDT 2002


----- Original Message -----
From: "Chris Blessing" <webguy at mail.rit.edu>
Sent: Friday, May 24, 2002 10:54 AM


> select article_id from paragraphs
> where sort_order = 1
> group by article_id
> having count(article_id) > 1

Chris,

select article_id
from paragraphs
group by article_id, sort_order
having count(*) > 1

Give this query a shot.  It should return any articles that have ANY
sort_orders repeated more than once.

-joshua





More information about the thelist mailing list