表Aid name
1 张三
2 李四
3 王五
用一条SQL语句想得到如下结果。
1 张三 2011-10-01
2 李四 2011-10-02
3 王五 2011-10-03
以此类推这种类似序列的时间,请问各位大侠能不能实现啊?
1 张三
2 李四
3 王五
用一条SQL语句想得到如下结果。
1 张三 2011-10-01
2 李四 2011-10-02
3 王五 2011-10-03
以此类推这种类似序列的时间,请问各位大侠能不能实现啊?
(select '1' as id, '张三' as name from dual
union
select '2', '李四' from dual
union
select '3', '王五' from dual
union
select '4', '周六' from dual)
select id, name, rownum, (trunc(sysdate,'yyyy')+rownum-1) custom from a
connect by rownum <=1
with a as
(select '1' as id, '张三' as name from dual
union
select '2', '李四' from dual
union
select '3', '王五' from dual
union
select '4', '周六' from dual)
select id, name, (trunc(sysdate,'yyyy')+rownum-1) custom from a
connect by rownum <=1
connect by rownum <=1
这句什么意思呢?
trunc(sysdate,'yyyy')+ruwnum-1
with a as
(select '1' as id, '张三' as name from dual
union
select '2', '李四' from dual
union
select '3', '王五' from dual
union
select '4', '周六' from dual)
select id, name, (trunc(sysdate,'mm')+rownum-1) custom from a
connect by rownum <=1;
(select '1' as id, '张三' as name from dual
union
select '2', '李四' from dual
union
select '3', '王五' from dual
union
select '4', '周六' from dual)
select id, name, (trunc(sysdate,'mm')+rownum-1) custom from a
connect by rownum <=1;
(select '1' as id, '张三' as name from dual
union
select '2', '李四' from dual
union
select '3', '王五' from dual
union
select '4', '周六' from dual)
select id, name, (trunc(sysdate,'yyyy')+rownum-1) custom,
to_date((trunc(sysdate,'yyyy')+rownum-1),'yyyy-MM-dd')
from a
connect by rownum <=1 这个我转换成时间类型提示失败 ,是什么原因啊