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!
hi all,
i have two tables subject table ,marks table in both table column column is subject_id
SUBJECT TABLE
MARKS TABLE
RULE IS
I WANT OUTPUT LIKE ABOVE PICTURE SUBJECT WISE WHICH STUDENT GET TOP MARKS ??
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.
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!