You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
386 B
18 lines
386 B
2 years ago
|
-- Query 30: Consommation la moins chère
|
||
|
|
||
|
SELECT
|
||
|
cns1.numcons AS 'numéro',
|
||
|
cns1.libcons AS 'libellé consommation',
|
||
|
cns1.prixcons AS 'prix le moins élevé'
|
||
|
FROM consommation cns1
|
||
|
WHERE
|
||
|
cns1.prixcons = (
|
||
|
SELECT MIN(cns2.prixcons)
|
||
|
FROM consommation cns2
|
||
|
);
|
||
|
|
||
|
/* == RESULT ==
|
||
|
"Numéro","Libellé Consommation","Prix le moins élevé"
|
||
|
100,"Café",1
|
||
|
*/
|