Advanced Search

select count distinct

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.