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

Post Details

Added on Feb 23 2017
2 comments
310 views