====== SQL ======
<WRAP left notice 80%>
  * description : SQL 관련 자료 등록
  * author      : 주레피
  * email       : dhan@repia.com
  * lastupdate  : 2020-03-18
</WRAP>
<WRAP clear/>

===== CASE...WHEN...THEN =====
[[https://devbox.tistory.com/entry/DBMS-CASEWHENTHEN|[DBMS_Oracle] CASE..WHEN...THEN]] \\
[[https://extbrain.tistory.com/46|[MySQL] CASE 기본 사용법]] \\

===== Date =====
Oracle : sysdate
<code sql>
    SELECT sysdate FROM dual;
</code>

MariaDB, Mysql : now()
<code sql>
    SELECT now() FROM dual;
</code>

===== Distinct =====
[[https://shaeod.tistory.com/281|[Oracle SQL] DISTINCT 키워드]]

===== 조건문 =====
  *[[wiki:database:sql:where|WHERE조건]]
===== Ref =====
[[https://okky.kr/article/353129|오라클의 sysdate와 같은 mysql혹은 mariadb의 함수?]]


===== Tip =====
  * [[https://pingukim.tistory.com/5|[MySQL/Oracle] max, min 값을 가진 row select 하기]]
  * [[https://webcoding.tistory.com/entry/SQL-%EC%84%9C%EB%B8%8C-%EC%BF%BC%EB%A6%AC%EC%9D%98-%EA%B0%9C%EB%85%90%EA%B3%BC-%EB%B3%84%EC%B9%ADALIAS-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0|[SQL] 서브 쿼리의 개념과 별칭(ALIAS) 사용하기]]

===== Troubleshooting =====
  * [[https://pganalyze.com/docs/log-insights/app-errors/U115|U115: Subquery in FROM must have an alias]]



{{tag>주레피 sql 천호동밤안개}}