Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR TYPESCRIPT

FIND TOP 3 students from math_11a table

select concat(first_name," ",last_name) as "top_3_leaders"
        from Students 
               inner join 
             (select student_id, sum(grades) as total from grades
              group by student_id
              order by sum(grades) desc
              limit 3
              ) as t1
where students.student_id = t1.student_id
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #FIND #TOP #students #table
ADD COMMENT
Topic
Name
6+4 =