參考答案:
select * from cinema where description != 'boring' and mod(id,2) = 1 order by rating desc
知識點補充:
奇數:mod(id,2)=1
偶數:mod(id,2)=0
排序:order by 列名 desc 倒叙 order by 列名 asc 正序
參考答案:
select * from cinema where description != 'boring' and mod(id,2) = 1 order by rating desc
知識點補充:
奇數:mod(id,2)=1
偶數:mod(id,2)=0
排序:order by 列名 desc 倒叙 order by 列名 asc 正序