SQL statement Description: exhibitiononline table primary key exhiid, exhibitiononline table with foreign key exhid, corresponding to exhibitiononline primary key exhiid; exhibitiononline table --------- one-to-many --------- exhibitiononline table, exhiid exists in all data in the exhibitor table.
SQL statement Description: exhibitiononline table primary key exhiid, exhibitiononline table with foreign key exhid, corresponding to exhibitiononline primary key exhiid; exhibitiononline table --------- one-to-many --------- exhibitiononline table, exhiid exists in all data in the exhibitor table.
SQL statement
Description: exhibitiononline table primary key exhiid. exhibitor table has a foreign key exhid, corresponding to the table exhibitiononline primary key exhiid;
Exhibitiononline table ---------> one-to-many <----------- exhibitor table
Function: Query all data in the exhibitiononline table that exhiid exists in the exhibitor, and sort the data according to the exhid quantity in the exhibitiononline table.
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