Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
bdlibre [2017/02/21 15:35] glaroc [Lier R avec PostgreSQL] |
bdlibre [2017/02/21 16:21] glaroc [Exercice 5 - Travailler avec plusieurs tables] |
||
---|---|---|---|
Line 523: | Line 523: | ||
WHERE lakes.lake_id=lakes_species.lake_id | WHERE lakes.lake_id=lakes_species.lake_id | ||
GROUP BY lakes.lake_id | GROUP BY lakes.lake_id | ||
- | ORDER BY Num_Species DESC LIMIT 20; | + | ORDER BY num_species DESC LIMIT 20; |
</file> | </file> | ||