【无标题】SQL+HIVE 题目:查询接下来5天要过生日的学生
SELECT * FROM (
SELECT birthday , month(current_date() ) nowmonth ,month(date_add(current_date(),5)) nextmonth ,month(to_date(birthday)) usermonth , day(current_date() ) nowday ,day(date_add(current_date(),5)) nextday
, day(to_d.
原创
2021-12-31 16:23:47 ·
876 阅读 ·
2 评论