[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