DRYな備忘録

Don't Repeat Yourself.

2013-04-27から1日間の記事一覧

副問い合わせメモ【SQL】

SELECT name AS player, (SELECT count(*) FROM votes WHERE votes.voted_id=membs.id) AS score FROM membs ORDER BY score DESC; +-------------+-------+ | player | score | +-------------+-------+ | name0さん | 5 | | name2さん | 5 | | name4さん |…