1..SELECT NAME,WEIGHT,BIRTHDAY FROM STUDENT WHERE BIRTHDAY IS NULL
2..
SELECT NAME,WEIGHT,BIRTHDAY||'1980/01/01' BIRTHDAY
FROM STUDENT WHERE BIRTHDAY IS NULL
UNION
SELECT NAME,WEIGHT,TO_CHAR(BIRTHDAY,'YYYY/MM/DD')
FROM STUDENT WHERE BIRTHDAY IS NOT NULL
3??????
2..
SELECT NAME,WEIGHT,BIRTHDAY||'1980/01/01' BIRTHDAY
FROM STUDENT WHERE BIRTHDAY IS NULL
UNION
SELECT NAME,WEIGHT,TO_CHAR(BIRTHDAY,'YYYY/MM/DD')
FROM STUDENT WHERE BIRTHDAY IS NOT NULL
3??????
解决方案 »
- 与大家讨论一个sql的对错。
- 怎样配置ORACLE 的DATA GUARD呀? 紧急求救,大量送分!
- plsql创建存储过程的疑问
- 这么简单的数据库查询语句都错了,但不知什么原因呀?
- 散分:请问oracle中怎么设table description和field description? 在线等待,谢谢
- 在WHERE子句中能否用数组?
- 提取库中数据生成数据文件(*.dat),请大家来探讨探讨呢?
- 给一张表插入5000条记录
- 我想在一台机器上调用另一台机器的oracle数据。
- Oracle中字符串格式varchar更改为日期格式date
- 两个pl\sql问题
- Oracle比SQL SERVER优越在什么地方?
2..
SELECT NAME,WEIGHT,BIRTHDAY||'1980/01/01' BIRTHDAY
FROM STUDENT WHERE BIRTHDAY IS NULL
UNION
SELECT NAME,WEIGHT,TO_CHAR(BIRTHDAY,'YYYY/MM/DD')
FROM STUDENT WHERE BIRTHDAY IS NOT NULL3..
SELECT * FROM STUDENT MINUS SELECT * FROM MELESTUDENT请问高手,第二个和第三个还有没有别的写法
2. select name,weight,decode(U.birhtday,'','1980/01/01',U.birhtday) birhtday from student U
3. select U.* from stduent U where not exists(select * from melestudent P
where U.Userid=P.Userid and U.Postid=P.Postid )
select NAME,WEIGHT,nvl(BIRTHDAY,'1980/01/01') from stduent
2.select * from student where (name,weightbirhtday) not in (select name,weight,birhtday from zzb_userposthis)