幾個sql案例

?

?

第一題
select 
Case When t.flag>0 Then "T" Else "F" End 
from 
(SELECT instr(TableA.col1,TableA.col2) as flag from TableA) t第三題
select s.* from student s ,(SELECT name,MAX(score) m from student GROUP BY name) t 
where 
s.name = t.name and s.score = t.m 
ORDER BY `name`第四題
select name, GROUP_CONCAT( 
CONCAT('{"',subject,'":',score,"}") 
)
from student GROUP BY name

?