create or replace view yearly_hire_totals as
select to_hire_date,count(*) total
from employees
group by hire_date
order by hire_date;
...全文
2405打赏收藏
如何让日期型字段只显示到年。
下面的hire_date日期型字段显示为月份,我想仅仅显示到年份就好,怎么写?? create or replace view yearly_hire_totals as select to_hire_date,count(*) total from employees group by hire_date order by hire_date;