Select several minimum values from row (MySQL)

Applications Programming
1

Hello there.
I've got the query like that

SELECT count(tour_id) AS cnt
FROM orders 
JOIN tours 
ON orders.tour_id=tours.id
GROUP BY tour_id

The result Is

cnt 
1
4
2
1
1

Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.
So the result will look like that

cnt 
1
1
1

WBR

2 
mysql>
mysql>
mysql> --
mysql> SELECT count(tour_id) AS cnt
    -> FROM orders
    -> JOIN tours
    -> ON orders.tour_id=tours.id
    -> GROUP BY tour_id;
+-----+
| cnt |
+-----+
|   1 |
|   4 |
|   2 |
|   1 |
|   1 |
+-----+
5 rows in set (0.00 sec)
mysql>
mysql>
mysql> --
mysql> select cnt
    -> from (select count(o.tour_id) as cnt
    ->       from orders o, tours t
    ->       where o.tour_id = t.id
    ->       group by o.tour_id) p
    ->       where cnt = (select min(cnt)
    ->                    from (select count(o.tour_id) as cnt
    ->                          from orders o, tours t
    ->                          where o.tour_id = t.id
    ->                          group by o.tour_id
    ->                         ) p
    ->                   );
+-----+
| cnt |
+-----+
|   1 |
|   1 |
|   1 |
+-----+
3 rows in set (0.00 sec)
mysql>
mysql>

tyler_durden

3

durden_tyler, I've impressed! Thank you very much!