Clash of multivalued attribute

Question

I am having a database having name and hobbies(as multivalued attribute) and I want to find out what is the count of occurence of more than one same value For example If this is a sample database

A reading
A dancing
B reading
B dancing

Then the result should be

List of hobbies  | Number of occurrence
-----------------|---------------------
reading, dancing | 2

And if the number of occurrences is different for each hobby? — juergen d, Mar 28 '15 at 20:04
Each hobby can have different occurence but my question is how many persons has both reading and dancing as their hobbies — Deep Joshi, Mar 28 '15 at 20:09

score 0 · Answer 1 · edited May 23 '17 at 12:06

0

I think you have a query like this:

SELECT hobbies, Count(*) As hNo 
FROM t
GROUP BY hobbies

That have a result set like this:

hobbies | hNo
--------+------
reading | 2 
dancing | 2

Now for this data-set you can follow answers of this question [Concatenate many rows into a single text string] to have them in one row.

edited May 23 '17 at 12:06

Community

1
1

answered Mar 29 '15 at 06:18

shA.t

16,580
5
54
111

Clash of multivalued attribute

1 Answers1