SQL TIP: FINDING TOTAL NO OF FEMALE AND MALE EMPLOYEES USING CASE
Page 1 of 1
SQL TIP: FINDING TOTAL NO OF FEMALE AND MALE EMPLOYEES USING CASE
maran Mon May 16, 2016 10:58 pm
SQL TIP: FINDING TOTAL NO OF FEMALE AND MALE EMPLOYEES USING CASE
EXAMPLE:
SELECT COUNT(*), SUM(CASE SEX WHEN 'F' THEN 1 ELSE 0 END) ,
SUM(CASE SEX WHEN 'M' THEN 1 ELSE 0 END) FROM EMPLOYEE
EXAMPLE:
SELECT COUNT(*), SUM(CASE SEX WHEN 'F' THEN 1 ELSE 0 END) ,
SUM(CASE SEX WHEN 'M' THEN 1 ELSE 0 END) FROM EMPLOYEE
maran- Admin
- Posts : 442
Join date : 2009-07-24 -
Similar topics» Find a String in a DBF records.
» Finding Maximum and Minimum Values in RPG Arrays
» How will you insert a case construct?
» SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
» Total # of records in a file
» Finding Maximum and Minimum Values in RPG Arrays
» How will you insert a case construct?
» SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
» Total # of records in a file
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|