2018-11-22 MySQL中取余与不等于的写法

2018-11-22  本文已影响0人  tomeetyou

select*fromcinemawheremod(id,2) =1anddescription !='boring'orderbyratingDESC

SELECT

*

FROM

cinema

WHERE

id%2 <> 0 and  description <> 'boring'

order by rating desc

上一篇 下一篇

猜你喜欢

热点阅读