wood burning stoves 2.0*
The moose likes JDBC and the fly likes query for maximum marks Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "query for maximum marks" Watch "query for maximum marks" New topic
Author

query for maximum marks

Samanthi perera
Ranch Hand

Joined: Jan 08, 2010
Posts: 510
this is my question
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Hi. Hope this is not your homework.


In your sql statement,
use the "max()" aggregation function to find the maximum marks,

and
to make the max() function aggregate on subject level,
group by subjectid by adding a "group by" clause.



OCUP UML fundamental and ITIL foundation
youtube channel
 
jQuery in Action, 2nd edition
 
subject: query for maximum marks
 
Similar Threads
WA #1.....word association
Passed but 44/80 on locking
SQL query for top ten students
how to select using check box
Re: Urgent with this program, Pls help