前6条件select top 6 * from t a where (select count(*) from t where waste_name=a.waste_name)>1 order by waste_id desc
显示前6条select top 6 * from t a where (select count(*) from t where waste_name=a.waste_name)>1 order by a.waste_id desc
top 和distinct好象不能同时用在一起 你试试把你的查询分解看看
--如果waste_id为a表的键编号,查询a表前六条waste_name不重复的记录! select top 6 a.* from a, (select waste_id=min(waste_id),waste_name from a group by waste_name) b where a.waste_id=b.waste_id
select top 6 * from t a where a.waste_id=(select top 1 waste_id from t where waste_name=a.waste_name) order by a.waste_id desc
--如果waste_id为a表的键编号,查询a表前六条waste_name不重复的记录,加个排序! select top 6 a.* from a, (select waste_id=min(waste_id),waste_name from a group by waste_name) b where a.waste_id=b.waste_id order by a.waste_id desc
select top 6 * from t a where a.waste_id=(select top 1 waste_id from t where waste_name=a.waste_name) order by a.waste_id desc
from t a
where (select count(*) from t where waste_name=a.waste_name)>1
order by waste_id desc
from t a
where (select count(*) from t where waste_name=a.waste_name)>1
order by a.waste_id desc
你试试把你的查询分解看看
select top 6 a.* from a,
(select waste_id=min(waste_id),waste_name from a group by waste_name) b
where a.waste_id=b.waste_id
from t a
where a.waste_id=(select top 1 waste_id from t where waste_name=a.waste_name)
order by a.waste_id desc
select top 6 a.* from a,
(select waste_id=min(waste_id),waste_name from a group by waste_name) b
where a.waste_id=b.waste_id
order by a.waste_id desc
from t a
where a.waste_id=(select top 1 waste_id from t where waste_name=a.waste_name)
order by a.waste_id desc