一条SQL把不同类别的记录各随机取出一条来

Question:
表:article
字段:
id        主键
fid      所属类别id
title    文章主题

同一个fid下有很多文章

怎么用一条SQL语句把每个不同的类别(fid)各随机取出一条记录来？

Answer:
select * from (select * from article order by rand()) as anothername group by fid;
<iframe frameborder="0" id="gn_notemagic" style="position: absolute; display: block; opacity: 0.7; z-index: 500; width: 17px; height: 21px; top: 172px; right: 226px;" src="http://www.google.com/gn/static_files/blank.html"></iframe>