Wednesday, May 13, 2009

postgresql order by count

select count(*), u.user_id
from aaa up
join user u
on u.user_id=up.user_id
where accepted=1
group by user_id
having count(*)>1
order by 1

No comments:

Post a Comment