How can we get Highest marks query in SQL, See Below :

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi All, I have a database with multiple records. See Table Structure Below :

id        Subject       Sub_category       Marks      User_Type

1         Science        Physics             4          tom
2         Science        Physics             2          tom                           
3         Science        Physics             1          tom                             
4         Science        Chemistry           4          tom                                  
5         Science        Chemistry           5          tom                               
6         Science        Biology             5          tom                            
7         Science        Biology             3          tom                         
8         Math           Alebra              2          tom
9         Math           Alebra              3          tom                          
10        Math           Statics             5          tom
11        Math           Statics             3          tom      
10        English        Grammer             5          tom
11        English        Grammer             1          tom      
10        English        Grammer             3          tom      
11        English        Theory              1          tom  
11        English        Theory              5          tom

Now I needs a query which shows addition marks of particular Sub_category, with count.. See below.

Subject       Sub_category       Marks      User_Type


Science        Physics             7          tom

Science        Chemistry           9          tom

Science        Biology             8          tom

Math           Alebra              5         tom

Math           Statics             8          tom

English        Grammer             9          tom

English        Theory              6          tom

<br />
Can any one have an idea, kindly share with me.

Posted 19-Sep-12 19:14pm

Mas11

Add a Solution

3 solutions

Solution 3

SQL

SELECT 
  Subject
, Sub_category
, SUM(Marks) AS Marks
, User_Type
FROM YourTable
GROUP BY
  Subject
, Sub_category
, User_Type

Posted 19-Sep-12 19:24pm

Kuthuparakkal

Comments

Mas11 20-Sep-12 1:37am

Thanks a lot !!.

Kuthuparakkal 20-Sep-12 2:13am

welcome buddy

Solution 1

This is why we have GROUP BY clauses[^].

Posted 19-Sep-12 19:22pm

Abhinav S

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Accepted Answer · 2012-09-19T19:23:00

Solution 2

SQL

select subject,sub_category,sum(marks) as marks,user_type 
from yourTbl
group by  subject,sub_category,user_type

Happy Coding!
:)

Posted 19-Sep-12 19:23pm

Aarti Meswania

Comments

Mas11 20-Sep-12 1:36am

Wonderfull aarti, u glad me a lot.. Thanks for ur answer.

Aarti Meswania 20-Sep-12 1:37am

welcome,
Glad to help you! :)