mysql ifNull函数
IFNULL() 函数用于判断第一个表达式是否为 NULL,如果为 NULL 则返回第二个参数的值,如果不为 NULL 则返回第一个参数的值。
IFNULL() 函数语法格式为:
IFNULL(expression, alt_value)
-- 栗子
select ifNull ((select distinct salary from Employee order by salary desc limit 1,1),null) as SecondHighestSalary
sql 字段为Null的用法
select * from student where score is NULL;
date
select * from product where start_date>'2022-05-04' and start_date <'2022-05-05'
datediff的用法
select w.Id from Weather as x join Weather as w on dateDiff(w.RecordDate,x.RecordDate)=1 and w.Temperature> x.Temperature