title: MySQL - how to fetch the top combinations of data using same table with multiple combinations of records?
body: <p>I have table called <code>response_drilldown</code> with the following structure.</p>
  <p>These are the my table fields and entries:</p>
  <pre><code>| answer_id | responder_id | question_id | answer        | level_id |
  |-----------|--------------|-------------|---------------|----------|
  | 1         | 1            | 25          | India         | 1        | 
  | 2         | 1            | 25          | Andhrapradesh | 2        |
  | 3         | 1            | 25          | Guntur        | 3        |
  | 4         | 2            | 25          | India         | 1        |
  | 5         | 2            | 25          | Andhrapradesh | 2        |
  | 6         | 2            | 25          | Guntur        | 3        |
  | 7         | 3            | 25          | India         | 1        |
  | 8         | 3            | 25          | Telangana     | 2        |
  | 9         | 3            | 25          | Hyderabad     | 3        |
  | 10        | 4            | 25          | India         | 1        |
  | 11        | 4            | 25          | Telangana     | 2        |
  | 12        | 4            | 25          | Warangal      | 3        |
  | 13        | 5            | 25          | India         | 1        |
  | 14        | 5            | 25          | Telangana     | 2        |
  | 15        | 5            | 25          | Nalgonda      | 3        |
  | 16        | 6            | 25          | India         | 1        |
  | 17        | 6            | 25          | Telangana     | 2        |
  | 18        | 6            | 25          | Hyderabad     | 3        |
  </code></pre>
  <p>So using the above example, How to get the combination of data using mysql query like :</p>
  <blockquote>
  <p>India &gt; Andhrapradesh &gt; guntur &gt; 2,</p>
  <p>India &gt; Telangana &gt; Hyderabad &gt; 2,</p>
  <p>India &gt; Telangana &gt; Warangal &gt; 1,</p>
  <p>India &gt; Telangana &gt; Nalgonda &gt; 1,</p>
  </blockquote>
  <p>Can anyone please give me the answer?</p>