> On 2016-04-10, at 14:04, Xin Liu <[email protected]> wrote:
> 
> show top 100 of student's achievement

MySQL query to get the 100 students with best achievements:

  select student_id, student_name, student_score
  from Students
  order by student_score desc
  limit 100

Greetings,

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/81DB60A6-F6EA-4FCE-827D-F2C381D57918%40xs4all.nl.
For more options, visit https://groups.google.com/d/optout.

Reply via email to