sql select 综合运用

1 ： 多个表联合查询

 select j.id,
         jt.Name,
        j.ApproveType ,
         j.ProductCode,
         j.CustomerCode,
         u.FullName,
         jf.Name as jfName,
         j.ExpectedTime
   from JudgeOrder as j
  join JudgeOrderType as jt  on j.JudgeType=jt.Id
  join [User] as u on j.SalesManCode=u.Name
  join JudgeOrderFormat as jf on j.FormatType=jf.id order by j.Id

2 ： sql 分页查询

   select top 5 * from judgeorder where id  not in (select top 10 id from judgeorder order by id) order by id   

3 ： sql 分页联合查询
    select top 5 j.id,
         jt.Name,
        (case when j.ApproveType='0' then '待评审' when j.ApproveType='1' then '销售已评审' when j.ApproveType='2' then '生产已评审' when j.ApproveType='3' then '评审完成' end) ap ,
         j.ProductCode,
         j.CustomerCode,
         u.FullName,
         jf.Name as jfName,
         j.ExpectedTime
   from JudgeOrder as j
  join JudgeOrderType as jt  on j.JudgeType=jt.Id
  join [User] as u on j.SalesManCode=u.Name
  join JudgeOrderFormat as jf on j.FormatType=jf.id where j.id  not in (select top 10 id from judgeorder order by id) order by j.id 

转载于:https://www.cnblogs.com/code-Officer/p/6207407.html