新手提问:select语句的问题 select time from dd where type=1 or type=2select time from dd union select time from dd where type=2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select time from dd where type in(1,2) 楼上的都对,但是不好意思我写漏了一个条件:我想返回1条记录 结果: time1 time22006-9-9 2006-8-8 select t1.time as time1,t2.time as time2 from (select time from dd where type=1)as t1,(select time from dd where type=2)as t2 楼上的出错阿:SQL 命令未正确结 把楼上的SQL改下:select t1.time as time1,t2.time as time2 from (select time from dd where type=1) t1,(select time from dd where type=2) t2 select (select time from dd where type = 1) , (select time from dd where type = 2 ) from dual ORACLE从Excel导入数据,出现乱码 oracle其实没那么简单 关于定义record类型,请教 Oracle 11g RAC系列一【分享】 qq好友表中如何存储? 如何更改oracle9i的sid? 各位高手看一下这个问题用存储过程可以解决吗? 关于记录的删除 varchar2和number的问题 请问各位大虾:sql sever 和 oracle的区别是什么啊? Oracle有没有象MsSQL2K样数据迁移呢? 关于oracle用户之间权限的问题
2006-9-9 2006-8-8
SQL 命令未正确结
select t1.time as time1,t2.time as time2 from (select time from dd where type=1) t1,(select time from dd where type=2) t2
, (select time from dd where type = 2 ) from dual