SQL語(yǔ)句
描述：exhibitiononline表主鍵exhiid， exhibitor表有外鍵 exhid，對(duì)應(yīng)表 exhibitiononline的主鍵exhiid;
exhibitiononline表---------> 一對(duì)多 <------------- exhibitor表
功能：查詢出 exhibitiononline表中，exhiid存在于表 exhibitor中的所有數(shù)據(jù)，并根據(jù) exhibitor表的exhid的數(shù)量排序
select * from exhibitiononline join
(select exhid,count(exhid) as s from exhibitor group by exhid) as t
on exhibitiononline.exhiid=t.exhid
order by t.s desc
更多信息請(qǐng)查看IT技術(shù)專欄
公眾號(hào)
事業(yè)單位
當(dāng)前位置：
公考類
招聘類
各類考試