mysql> select EVENEMENT_ID, MIN(DEBUT) as Deb FROM REPRESENTATION WHERE EVENEMENT_ID in (1119,1118,1117) GROUP BY EVENEMENT_ID ORDER BY Deb;
+--------------+---------------------+
| EVENEMENT_ID | Deb |
+--------------+---------------------+
| 1119 | 2005-08-20 08:00:00 |
| 1117 | 2005-08-29 19:00:00 |
| 1118 | 2005-08-31 19:00:00 |
+--------------+---------------------+
3 rows in set (0.00 sec)
mysql> select EVENEMENT_ID, MIN(DEBUT) as Deb FROM REPRESENTATION WHERE EVENEMENT_ID in (1119,1118,1117) GROUP BY EVENEMENT_ID ORDER BY 2;
+--------------+---------------------+
| EVENEMENT_ID | Deb |
+--------------+---------------------+
| 1119 | 2005-08-20 08:00:00 |
| 1117 | 2005-08-29 19:00:00 |
| 1118 | 2005-08-31 19:00:00 |
+--------------+---------------------+
3 rows in set (0.00 sec)
Partager