top n:選出查詢結果的前n項,可改為 top n percent 形式:選出查詢結果的前百分之n項; inner join:內連接查詢,可改為left join(左連接)、right join(右連接); ...
select distinct top n * from t1 inner join t2 on ... join t3 on ... where ... group by ... having ... order by ...
top n:選出查詢結果的前n項,可改為 top n percent 形式:選出查詢結果的前百分之n項;
inner join:內連接查詢,可改為left join(左連接)、right join(右連接);