select ID,NAME from (
select ID,NAME,1 as ORD from a where name like 's' //结果必须在前
select ID,NAME,2 as ORD from a where name not like 's') A
order by ORD,id
select ID,NAME,1 as ORD from a where name like 's' //结果必须在前
select ID,NAME,2 as ORD from a where name not like 's') A
order by ORD,id
union
select ID, Name from a where name not like 's'
union all
select ID, Name from a where name not like 's' j9988(j9988)的方法好
union all
select ID,NAME,2 as ORD from a where name not like 's'
union
select ID,NAME from a where name not like 's'
union all
select ID, Name from a where name not like 's' j9988(j9988)的方法好
select ID,NAME,1 as ORD from a where name like 's' //结果必须在前
select ID,NAME,2 as ORD from a where name not like 's') A
order by ORD,id
这一句有语法错误,第二行后面是不是要加点什么?union all可以
select ID,NAME,1 as ORD from a where name like 's'
union
select ID,NAME,2 as ORD from a where name not like 's') B
order by ORD,id
select ID,NAME,1 as ORD from a where name like 's'
union all
select ID,NAME,2 as ORD from a where name not like 's') A
order by ORD,id
select ID,NAME,1 as ORD from a where name like 's'
union all
select ID,NAME,2 as ORD from a where name not like 's') A
order by ORD,id