SQL語(yǔ)句 描述：exhibitiononline表主鍵exhiid， exhibitor表有外鍵 exhid，對(duì)應(yīng)表 exhibitiononline的主鍵exhiid; exhibitiononline表--------- 一對(duì)多 ------------- exhibitor表 功能：查詢出 exhibitiononline表中，exhiid存在于表 exhibitor中的所有數(shù)據(jù)

　　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

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com