To get to know about SELF JOIN & DATE type format, let's solve Leetcode problem in https://leetcode.com/problems/rising-temperature/ . If you want to know about SELF JOIN, you can go HERE.What this asking for is, "Select 'ID' with a higher temperature than yesterday." And here's the Weather table.Weather table:+----+------------+-------------+| id | recordDate | temperature |+----+------------+-..

What is MySQL SELF JOIN?MySQL을 공부하며 제일 헷갈리는게 조인인데 (left join, right join, inner join 등등등) SELF JOIN이라는 놈도 있다ㅋㅋ SELF JOIN이란 무엇인가 . . 쉽게 말하면 자기 자신을 조인하는 놈이다. 여기서 생기는 의문The most confusing thing studying MySQL is JOIN (including left join, right join, inner join, etc.). There is also a thing called SELF JOIN. Then, "What is SELF JOIN??". Simply put, It is the one who joins itself literally. The que..

There is a challenge in HackerRank. We should find the result of abandoning the decimal point abandoned, not rounded up. How do we deal with decimals in MySQL? we've seen the round. But we've rarely seen abandonment before. Anyway, let's find out how to solve the problem of dealing with decimal points.MySQL Decimal Abandonment(Down) MethodThe way to abandon the decimal point is to use FLOOR righ..