For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Write a query to display excepted output
Hi, User_YBZOV Here's one way:
SELECT COUNT (CASE WHEN gender = 'M' THEN 1 END) AS male , COUNT (CASE WHEN gender = 'F' THEN 1 END) AS female FROM employee ;
If you'd care to post CREATE TABLE and INSERT statements for the samp,e data, then I could test this. SELECT ... PIVOT is another way.
Write a query to display excepted output