Question

ASP把数据表firm中f_cat字段下的数据不重复地读取出来，并且要求f_pass=1，怎么实现?

SELECT DISTINCT * FROM firm WHERE f_pass = ? ORDER BY f_date DESC
我写了一句实现不了，效果这个样子的http://www.wysls.com

Answer 1

楼主试试以下SQL仅选择一个f_cat字段
SELECT DISTINCT(f_cat) FROM firm WHERE f_pass = ? ORDER BY f_date DESC
如果需要选择多个字段的话，假设自增型字段名称是id的话
select * from firm where id in(Select min(id) FROM firm group by f_cat) and f_pass = ? ORDER BY f_date DESC