File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
SQL query for top ten students
how to select using check box
Re: Urgent with this program, Pls help
WA #1.....word association
Passed but 44/80 on locking
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014