Quick Inquiry

Learning SQL, trying to figure out how to get a gender count in SQL ?

Yogesh Kumar
04-May-2022
0

Learning SQL, trying to figure out how to get a gender count in SQL ?

 with GenderTable AS 
(
 SELECT 
 CASE 
   WHEN 'Gender ID'=1 Then  'Female' 
   Else 'Male' 
 END AS gender 
 FROM  CLIENT
)
SELECT count(gender), gender
FROM GenderTable
GROUP BY gender
;

You can try this too using the Common Table Expression

39 0 7

Write a Comments

* Be the first to Make Comment

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online