?????????????????е????
??????1??from????Table1??Table2??е???????????????????е??????????5*5=25?У??????????VT1
??????2??on?????VT1?е???ЩTable1.id=Table2.id???????У??????????VT2??
??????3??inner join?????????????????????VT2???????outer join????left join??right join??full join??????????????????????????VT1???????????????VT2??????VT3.
??????4??where?????VT3??Table1.id<4???????????VT4.
??????5??group by??????Table1.id???з??顣
??????6??COUNT????о?????????????Table1.id??????????????????????VT5
??????7??having?????VT5??Table1.id<3?????н???????????VT6
??????8??select?????VT6????????У????????VT7
??????9??distinct????VT7??????????????????VT8
??????10??order by????VT8????????Table1.id???????????????????????μ??VT9???????????α?VC9??
??????11??top?????α?VC9??????????????????????????1?У??????????VT10.
????????????????????SQL??佫VT10??????????á?
?????????????дSQL??????????????????????дSQL????????SQL?????????????????????????????????????
??????????????????????????????????????????????????????????????????????????????