반응형
Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 |
Tags
- UE5
- event
- priority_queue
- routes
- Props
- bit
- component
- Context
- DP
- nodeJS
- state
- 비트연산
- map
- MySQL
- c++
- css
- array
- count
- leetcode
- treenode
- axios
- Callback
- Navigation
- JSX
- React
- BinaryTree
- node.js
- route
- queue
- server
Archives
- Today
- Total
목록distinct (1)
우사미 코딩
[MySQL] 중복값 계산 (COUNT, DISTINCT)
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York' and 'Bengalaru'. The query returns , because . 이 이미지에는 데이터베이스의 'STATION' 테이..
MySQL
2024. 1. 3. 09:59