问简单的postgresql

qj_zhai

SELECT
count(qid) AS x,
"public".anwsers.qid,
"public".anwsers."content",
"public".anwsers.a_time,
"public".anwsers.uploadfile,
"public".anwsers.a_usr,
"public".anwsers."id"
FROM anwsers
group by qid,a_usr,a_time,uploadfile,id,"content"

表格详情是这样的，
id，是序列，qid是外键
求筛选出唯一的qid的行
mysql的是 select count(qid) as x,* from anwser group by qid order by desc

sychangchun

PG也可以的啊。按MYSQ的方法。