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> | ||
