sqlserver与oracle的with语句,语法一样

anysql

都是适用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;