Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need a query

0614Feb 23 2017 — edited Mar 17 2017

hi all,

i have two tables subject table ,marks table in both table column column is subject_id

SUBJECT TABLE

pastedImage_3.png

MARKS TABLE

pastedImage_6.png

RULE IS

pastedImage_5.png

pastedImage_4.png

I WANT OUTPUT LIKE ABOVE PICTURE SUBJECT WISE WHICH STUDENT GET TOP MARKS ??

Comments

EdStevens

Isn't this just a duplicate of sql query

Looking at your recent posting history, it appears you are simply trying to get the community to do your homework.

Sheeri

Common MySQL Queries is an EXCELLENT resource to read up on how to do different types of queries. I think what you need is under aggregation. I hope this helps you find what you need!

1 - 2

Post Details

Added on Feb 23 2017
2 comments
317 views