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

[远程Scada]

(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排序

[Softlee81307]

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

[LBYYBL]

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

[Softlee81307]

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 desc

[daijingjie2002]

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 id

[xluzhong]

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

[pbsql]

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

[xluzhong]

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

[远程Scada]

没有看清题意啊

[Qihua_wu]

(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)