Description: Useful SQL statement
select a.S# from (select s#,score from SC where C#= 001 ) a,(select s#,score
from SC where C#= 002 ) b
where a.score>b.score and a.s#=b.s#
To Search:
File list (Check if you may need any files):
Useful SQL statement.txt
Download