https://leetcode.com/problems/find-customer-referee/
Find Customer Referee - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
<>
!=
서로 같은 뜻으로 같지 않다를 나타내며 성능 차이는 없다.
다만, 문제에서도 알 수 있듯이 NULL은 처리가 되지 않기 때문에 따로 처리해줘야 한다.
Reference
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_not-equal
MySQL :: MySQL 8.0 Reference Manual :: 12.4.2 Comparison Functions and Operators
12.4.2 Comparison Functions and Operators Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to ope
dev.mysql.com
'자료구조 알고리즘 > 코딩테스트' 카테고리의 다른 글
[MySQL] left join, left outer join (0) | 2022.05.27 |
---|---|
[MySQL] null-safe equal <=>, = (0) | 2022.05.27 |
77484 로또의 최고 순위와 최저 순위 (0) | 2022.02.03 |
92334 신고 결과 받기 (0) | 2022.02.02 |
Insert into a Cyclic Sorted List (0) | 2022.01.30 |