ORACLE how to implement the function of the following SQL
Select *
The from setudent s
Left the join (select a.n ame, a.c lassid
The from clase a
Where a.c lassid=s.c lassid) b
On biggest lassid=s.c lassid

CodePudding user response:

- not so? Advice to give you the test data and the result of your expectations, it is ok to use excel,
Select *
The from setudent s
Left the join clase a
On a.c lassid=s.c lassid