当然可以,标准SQL都支持
不用别名,直接在 Select a1,b1,c1
from (Select a as a1,b as b1,c as c1,d as d1,e as e1
from tabe
where ......) where....
不用别名,直接在 Select a1,b1,c1
from (Select a as a1,b as b1,c as c1,d as d1,e as e1
from tabe
where ......) where....
解决方案 »
- 如何实现DELPHI程序运行后在就直接在右下角
- 关于DELPHI写的WEBSERVICE,总是使IIS挂掉的问题
- 如何解决XP的最多10个用户数限制??
- 如何用RegQueryValue 或 RegQueryValueEx读取注册表 'HKEY_Classes_root\ExcelAddin.Calcu\Sclid'的默认值?
- 请教:sql server 2000 中的 bigint ,是 8 位长度,是吗?在delphi 是哪个类型和它对应?谢谢!
- 【板务醒目】辞去 Windows SDK/API 板斑竹职务 10/10【散分醒目】
- 在数据编程的时候 控件过多的话 布局控制很难 大家有什么好的方法嘛
- 怎样限制Combobox框不能输入东西,谢谢!!
- 准备离开
- s请教随机函数的用法
- 看过我贴子(http://www.csdn.net/expert/topic/958/958167.xml?temp=.1907923)的朋友来这里领分(3),实现我的承诺,每人20
- 急,三层结构中双子表数据更新,搞了一个上午,还没找到问题所在,具体进来看一下,拜托了
from (Select a as a1,b as b1,c as c1,d as d1,e as e1
from tabe
where ......) where....
可以這么做嘛
create view Va
as
Select a as a1,b as b1,c as c1,d as d1,e as e1
from tabe
where ......goSelect a1,b1,c1
from Va
where......
begin
close;
sql.add('Select a as a1,b as b1,c as c1,d as d1,e as e1
from tabe where ......');
open; //再次查询
Locate('字段名','查找值',[loPartialKey]);
end;