Forum Stats

  • 3,770,020 Users
  • 2,253,049 Discussions
  • 7,875,269 Comments

Discussions

need a query

0614
0614 Member Posts: 121 Red Ribbon
edited Mar 17, 2017 2:49AM in MySQL Community Space

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 ??

Gbenga AjakayeDave Stokes-MySQL Community Team-Oracle

Answers