dimanche 24 mai 2015

How to get the count of each distinct value in Multiple columns and get the result in separate columns?

I need the following table to be queried to get the result given below the table.

Table

| Name | Age | slot | |-------|--------|---------------| |A |20 | 1 | |B |30 | 2 |
|C |30 | 1 |
|D |20 | 1 |
|E |40 | 2 |
|F |40 | 3 |

|G |50 | 3 |

Result:

|Age |Age_Count |Slot |Slot_Count|

|20 | 2 |1 |3 |

|30 | 2 |2 |2 |

|40 | 2 |3 |2 |

|50 | 1 |

While searching stackoverflow i found this question for single column question and there is [this link for multiple columns] (get the count of each distinct value in "Multiple" columns) question. The answers from the second link (for the multiple coulmn's distinct count) is displayed under a single column and my requirement is i guess quite different from the answers posted there.

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire