Sql Query Doubt

[nikhilboorla]

wAts the query fOr Finding no of employees joined in year 2005 from emp table.

[BAPURE]

SELECT to_date(EMP_JN_DT,'MON') "Month", EMP_NO "Employees"

FROM EMP_REG
WHERE EMP_JN_DT between date '2009-01-01' AND date '2009-12-31'
GROUP by "Month"
ORDER BY 1;

[150bryant]

select Employee Name, Join date from EMP table

where year(join date) = '2005'

[loveindia]

select count(empid)
from employees
where year(empstartdate) = 2005

please dont forget to like and share.. lol