【无标题】SQL+HIVE 题目：查询接下来5天要过生日的学生

最新推荐文章于 2025-03-15 11:11:26 发布

原创最新推荐文章于 2025-03-15 11:11:26 发布 · 935 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #hive #数据库

ORACLE 同时被 2 个专栏收录

3 篇文章

订阅专栏

java

1 篇文章

订阅专栏

本文探讨了如何通过SQL查询技巧，比较当前月与下个月，同时结合用户生日数据，预测用户可能的行为变化。查询涉及生日月份、当前和未来天数，旨在揭示潜在的时间趋势和个性化规律。

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_date(birthday))   userday    from tablename
)

WHERE 
(
nowmonth  != nextmonth AND
(
  (nowmonth==  usermonth AND userday>  nowday   )
  or (nextmonth ==  usermonth AND  userday <= nextday  ) 
)
)
OR  (nowmonth  == nextmonth   AND   userday   >  nowday  AND  userday <=nextday )
;