일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- nlp논문
- 서브쿼리
- LSTM
- SQL코테
- 코딩테스트
- update
- sigmoid
- 자연어처리
- 표준편차
- t분포
- 논문리뷰
- sql
- airflow
- 자연어 논문 리뷰
- leetcode
- 그룹바이
- inner join
- GRU
- SQL 날짜 데이터
- 설명의무
- HackerRank
- CASE
- NLP
- Statistics
- torch
- 짝수
- MySQL
- 카이제곱분포
- 자연어 논문
- Window Function
- Today
- Total
목록update (2)
HAZEL
196. Delete Duplicate Emails >> 문제 Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email | +----+------------------+ | 1 | john@example.com | | 2 | bob@example.com | | 3 | john@example.com | +----+------------------+ Id is the primary key column for this table. For example, afte..
627. Swap Salary >> 문제 +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | | sex | ENUM | | salary | int | +-------------+----------+ id is the primary key for this table. The sex column is ENUM value of type ('m', 'f'). The table contains information about an employee. Write an SQL query to swap all 'f' and 'm' values (i.e., change all 'f..