欢迎投稿

今日深度:

一个标准sql语句模板,

一个标准sql语句模板,


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(右连接);

 

www.htsjk.Com true http://www.htsjk.com/Sql_Server/37833.html NewsArticle 一个标准sql语句模板, 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 形式:选出查询结果的前...
相关文章
    暂无相关文章
评论暂时关闭