Question

SQL查询去重复并排序

提问一个那位大侠出来相救吧~~分少可以加~~查询两张表,先看表吧~~A表...一个是eid,一个是名称, B表....eid是对应的不用说, 要求查询在B表出现过的企业名称,不重复,并且根据时间倒序.....

Answer 1

select distinct Name from A where EId in(select Eid from B group by Eid) 要求查询在B表出现过的企业名称,不重复 这样就够了.至于根据时间倒叙 和结果没影响.

Answer 2

select a.*,addtime from
(
select max(addtime) addtime,eid from b group by eid
)t left join a on t.eid=a.eid
order by addtime desc