摘要:
常用分析函数: 1. first,last --假设a := min(奖金) keep(dense_rank first order by 工资) --假设工资最少为1000,a为在工资等于1000的员工取最小的奖金 --假设b := min(奖金) keep(dense_rank last ord 阅读全文
摘要:
1. WITH AS 示例 with e as (select * from employees), d as (select * from departments) select * from e,d where e.department_id = d.department_id and d.de 阅读全文
摘要:
1.select trunc(sysdate) from dual 2.select trunc(sysdate, 'mm') from dual 3.select trunc(sysdate,'yy') from dual 4.select trunc(sysdate,'dd') from dua... 阅读全文