A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
REST with Spring (video course)
this week in the
JDBC and Relational Databases
query for maximum marks
Joined: Jan 08, 2010
Feb 10, 2010 22:02:17
this is my question
Given a Table named “Students” which contains studentid, subjectid and marks. Where there are 10 subjects and 50 students. Write a Query to find out the Maximum marks obtained in each subject
Joined: Dec 20, 2006
Feb 11, 2010 00:14:31
Hi. Hope this is not your homework.
In your sql statement,
use the "max()" aggregation function to find the maximum marks,
to make the max() function aggregate on subject level,
group by subjectid by adding a "group by" clause.
OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: query for maximum marks
Counting the number of numbers in SQL
Problem in iReport3.7.1 ,Struts2
questions related to sql queries
JPA mapping question
Three problems with mysql...
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015