This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
bdlibre [2017/02/21 15:35]
glaroc [Lier R avec PostgreSQL]
bdlibre [2017/02/21 16:21] (current)
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>​