select * from (select top 4 * from( select top 10 * from
(select * from zidian where ename not like 'name' )
as t0 order by ename desc ) as t1 order by ename asc ) as t2 order by ename descselect * from zidian where ename like 'name'
(select * from zidian where ename not like 'name' )
as t0 order by ename desc ) as t1 order by ename asc ) as t2 order by ename descselect * from zidian where ename like 'name'
解决方案 »
- 请指教:我想脱离windows2003中文版,安装新的windows2008中文版和vs.net2008中文版,就是不知能带来哪些不便和冲突。我现在用的有VB6、水晶报表9.2,office2003中文版、SQL SERVER 2000+sp3a、Inst
- 请问会一点ACCESS2003,再学SQL是不是会很容易?
- 求一思路的解决办法。SQL语句
- 求统计周,月,年 数据的语句
- 关于触发器的问题,update一个单元格,如果update的值和原有的记录有重复出提示,啥办?
- 求助连接过多拒绝服务的问题
- 向高手求救:xp 下安装sql server 2000 Enterprise Edition 的问题
- 高手帮忙看看,已经几天了都没有解决,生成年报表,按stcode,pcode分组每月都要在报表里有,如果该月没有数据此显示-1
- 如何在sql中将数据根据自定义的要求写入xls?
- 请问“大力”及其他高手,在程序中怎样调用compute by子句得到的分类汇总及明细?
- 向日期类型字段插入时间的问题
- 请问一个触发器
union all?
(select * from zidian where ename not like 'name' )
as t0 order by ename desc ) as t1 order by ename asc ) as t2 order by ename descunion allselect * from zidian where ename like 'name'
可以使用union 或union all--不合并重复记录
select * from A
union all
select * from B--合并重复记录
select * from A
union
select * from B
(select * from zidian where ename not like 'name' )
as t0 order by ename desc ) as t1 order by ename asc ) as t2 order by ename desc)union all (或者是union)(select * from zidian where ename like 'name')
???
lz 你的sql好像有逻辑问题
(select * from zidian where ename not like 'name' )
as t0 order by ename desc ) as t1 order by ename asc ) as t2
union all
select * from zidian where ename like 'name') b
order by ename desc
????
from
(select top 4 *
from ( select top 10 *
from (select * from zidian where ename not like 'name' ) as t0
order by ename desc ) as t1
order by ename asc ) as t2
order by ename descselect * from zidian where ename like 'name'写成这样就好看多了。
from zidian
where ename not like 'name'
order by ename desc
union all
select * from zidian where ename like 'name'
ename like 'name'
不就是相当于ename = 'name'吗?
应该是ename like '%name%'吧?