sql題人員表:PersonSet([ID],Name,Sex)勤工儉學記錄表:RecordSet([ID],Sumary,PersonID)勤工儉學的次數(shù)倒敘排列人每當做一次義務就記錄一次插入一條記錄
2 回答
慕姐8265434
TA貢獻1813條經(jīng)驗 獲得超2個贊
select count(b.PersonID) as [次數(shù)],a.Name from PersonSet a innerjoin RecordSet b on a.id = b.PersonID group by b.PersonID,a.Name order by count(b.PersonID) desc
- 2 回答
- 0 關注
- 366 瀏覽
添加回答
舉報
0/150
提交
取消