dimanche 26 juin 2016

How to select a particular row of query result

I have a following table in my Oracle database: How can I select the course which is done by most of the students? I am trying multiple variations in following SQL query but it's not working - select count(course) as pcourse, course from studies group by course order by pcourse dec;

Aucun commentaire:

Enregistrer un commentaire