题解 | #判断其是否有过购买记录#
判断其是否有过购买记录
https://www.nowcoder.com/practice/5cddad8995974b0c915ab89961428ee0
select customer_id, if(latest_place_order_date>1,1,0) as if_placed_order from customers_info
请问一下各位大佬,我用>1判断是不是也可以?答案是通过了,但我不知道这么写在原理上符不符合逻辑
判断其是否有过购买记录
https://www.nowcoder.com/practice/5cddad8995974b0c915ab89961428ee0
select customer_id, if(latest_place_order_date>1,1,0) as if_placed_order from customers_info
请问一下各位大佬,我用>1判断是不是也可以?答案是通过了,但我不知道这么写在原理上符不符合逻辑
相关推荐