sqlsquare

分类

题解(46)

/ 注册

全部文章（共13篇）

题解 | #检索产品名称和描述（三）#

select prod_name,prod_desc from Products where prod_desc like "%toy%" and prod_desc like "%carrots%"

Mysql

2022-03-02

1 361

题解 | #牛客直播转换率#

select c.course_id,course_name,round(sum(if_sign)*100/count(if_vw),2) from course_tb c join behavior_tb b where c.course_id=b.course_id group by c.cou...

Mysql

2022-01-22

0 369

题解 | #插入记录（一）#

cost = (int)(price>=5000 ? price0.6 : ( price>=2000 ? price0.7 : (price>=500 ? price0.8 : (price>=100 ? price0.9 : price))));

Java

2022-01-07

11 1227