Horje
group by join columns per table Code Example
group by join columns per table 
SELECT 
    e.department_id,
    department_name,
    e.job_id,
    job_title,
    COUNT(employee_id)
FROM
    employees e
        INNER JOIN
    departments d ON d.department_id = e.department_id
        INNER JOIN
    jobs j ON j.job_id = e.job_id
GROUP BY e.department_id , e.job_id;
Code language: SQL (Structured Query Language) (sql)
Source: www.sqltutorial.org



Sql

Related
oracle sql timestamp Code Example oracle sql timestamp Code Example
write sql query to show the details start from digit Code Example write sql query to show the details start from digit Code Example
sql substring before last occurrence of character Code Example sql substring before last occurrence of character Code Example
get first match in each group mysql query Code Example get first match in each group mysql query Code Example
oracle create package body Code Example oracle create package body Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje