Posted By

goodkail on 07/06/06


Tagged

select count distinct


Versions (?)

select count distinct


 / Published in: SQL
 

  1. SELECT DISTINCT pt_services.service_bezeichnungen, pt_class_services.class_services_name, count(*) AS total
  2. FROM service
  3. INNER JOIN pt_services
  4. ON service.id_pt_service = pt_services.id_pt_service
  5. INNER JOIN pt_class_services
  6. ON service.id_class_services = pt_class_services.id_class_services
  7. GROUP BY pt_services.id_pt_service, pt_class_services.id_class_services;

Report this snippet  

You need to login to post a comment.