mysql in functions

Question

waqtd number of employees hired in the same day in to same department in employee table #this table is in oracle 11g demo table for practing but i am studying my sql

Amira Bedhiafi · Answer

While your question is missing sample data, but this is an essay : CREATE TABLE employees ( employee_id NUMBER , hire_date DATE , department_id NUMBER ) ; INSERT INTO employees (employee_id,hire_date,department_id) VALUES (1,TO_DATE( '20210101' , 'YYYYMMDD' ),5); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (5,TO_DATE( '20210101' , 'YYYYMMDD' ),5); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (10,TO_DATE( '20210101' , 'YYYYMMDD' ),5); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (2,TO_DATE( '20210102' , 'YYYYMMDD' ),5); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (3,TO_DATE( '20210102' , 'YYYYMMDD' ),1); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (23,TO_DATE( '20210102' , 'YYYYMMDD' ),5); INSERT INTO employees (employee_id,hire_date,department_id) VALUES (55,TO_DATE( '20210102' , 'YYYYMMDD' ),6); SELECT department_id, hire_date, COUNT (employee_id) AS CountOfEmployees FROM employees GROUP BY department_id, hire_date ORDER BY department_id, hire_date

Amira Bedhiafi · Answer

Can you please share a sample of your data and the related tables?

Rajanikant Hawaldar · Answer

select count(emp) as num_emp where date=.... you can order by date btn may be a group by + order by clause