MySQL Forums
Forum List  »  Stored Procedures

How do I pivot the following in MySQL
Posted by: Hussain Shaherwala
Date: September 10, 2019 04:47AM

Hello,
I want to pivot the following table in MySQL. The name of the table is fp_homevisit_anc_regis. There is a column called coid and another column called womanid.
I want to show the data coid wise and i want to should the count distinct of womanid. I want to see the distinct count of womanid per coid.

Options: ReplyQuote


Subject
Views
Written By
Posted
How do I pivot the following in MySQL
714
September 10, 2019 04:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.