Andy Matthews said:
> Anyone care to chime in on this? I've posted a thread which hasn't
> gotten many responses yet and I'm wondering if any of you SQL
> wizards have input.
>
> http://www.sitepoint.com/forums/showthread.php?t=389438
SELECT
v_player,
CASE
WHEN MAX(v_pop) = MIN(v_pop) THEN 'same'
ELSE 'changed'
END AS activity
FROM x_world
GROUP BY
v_player
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242910
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
