일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- 자연어처리
- SQL 날짜 데이터
- torch
- GRU
- nlp논문
- Window Function
- NLP
- 코딩테스트
- LSTM
- 짝수
- 표준편차
- HackerRank
- airflow
- SQL코테
- 카이제곱분포
- 자연어 논문 리뷰
- update
- CASE
- leetcode
- 논문리뷰
- MySQL
- 서브쿼리
- sql
- 설명의무
- 그룹바이
- t분포
- inner join
- 자연어 논문
- Statistics
- sigmoid
- 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..