重庆思庄Oracle、Redhat认证学习论坛

标题: sqlserver与oracle的with语句,语法一样 [打印本页]

作者: anysql 时间: 2017-5-4 10:45
标题: sqlserver与oracle的with语句,语法一样
都是适用sql 99标准:

with dep_emp(部门,人数)
as (select department_name,count(*) from employees e,departments d where e.department_id=d.department_id group by department_name)
select * from dep_emp;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)