合并排序？？？？？？？？？？？？？？？

(SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*灯芯绒*'   order   by   jt   desc)   union   all   (SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*仿平绒*'   order   by   jt   desc)  
   
  我的要求是灯芯绒在前按jt排序，仿平绒在后也按jt排序  
  问题点数：50、回复次数：9Top

1 楼Softlee81307（孔腎）回复于 2005-01-24 10:11:22 得分 0

SELECT   *   FROM   qiye   where   Bigclass='003'   and   (title   like   '*灯芯绒*'   or   title   like   '*仿平绒*')   order   by   jt   desc     就行了Top

2 楼LBYYBL（o_o）回复于 2005-01-24 10:11:57 得分 0

SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*灯芯绒*'    
  union   all  
  SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*仿平绒*'   order   by   jt   descTop

3 楼Softlee81307（孔腎）回复于 2005-01-24 10:14:25 得分 0

select     *     from   (  
  SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*灯芯绒*'    
  union   all    
  SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*仿平绒*'   )   a  
  order   by   jt   descTop

4 楼daijingjie2002（艰苦创业）回复于 2005-01-24 10:15:21 得分 0

select   *,id=case   when   title   like   '%灯芯绒%'   then   1   when   title   like   '%灯芯绒%'   then   2   end     from    
  (SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*灯芯绒*'   order   by   jt   desc)   union   all   (SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*仿平绒*'   order   by   jt   desc)   as   ww   order   by   idTop

5 楼xluzhong（Ralph）回复于 2005-01-24 10:16:06 得分 0

SELECT   *   FROM   qiye   where   Bigclass='003'    
  order   by   title   case  
                                when   '*灯芯绒*'   then   1  
                                when   '*仿平绒*'   then   2  
                                end,  
                                jt   descTop

6 楼pbsql（风云）回复于 2005-01-24 10:16:55 得分 50

select   *   from   (SELECT   top   100   percent   *   FROM   qiye  
      where   Bigclass='003'   and   title   like   '*灯芯绒*'   order   by   jt   desc)   t1  
  union   all  
  select   *   from   (SELECT   top   100   percent   *   FROM   qiye  
      where   Bigclass='003'   and   title   like   '*仿平绒*'   order   by   jt   desc)   t2  
  Top

7 楼xluzhong（Ralph）回复于 2005-01-24 10:17:36 得分 0

SELECT   *   FROM   qiye    
  where   Bigclass='003'    
  order   by   title   case  
                                when   like   '*灯芯绒*'   then   1  
                                when   like   '*仿平绒*'   then   2  
                                else   3  
                                end,  
                                jt   desc  
  Top

8 楼cxwall（寂寞的人）回复于 2005-01-24 10:22:44 得分 0

没有看清题意啊  
  Top

9 楼Qihua_wu（小吴）回复于 2005-01-24 10:34:05 得分 0

(SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*灯芯绒*'   order   by   jt   desc)    
  union   all    
  select   *   from   (SELECT   *   FROM   qiye   where   Bigclass='003'   and   title   like   '*仿平绒*'   order   by   jt   desc)  
  Top

相关问题

• 灯芯绒
• bigclass
• 仿平绒
• jt
• title
• union
• from qiye where
• orderby jt desc
• select

• 帖主：cxwall
• pbsql

• SQL Server类图书