FirebirdSQL logo

Exemples COUNT

Example 1. En utilisant la fonction COUNT
SELECT
  dept_no,
  COUNT(*) AS cnt,
  COUNT(DISTINCT name) AS cnt_name
FROM employee
GROUP BY dept_no
Voir aussi :

SELECT.