목록mysql (3)

SOOM_BLOG [숨숨 블로그]

MySql, MariaDB에서 connect by level 구현하기

-- ORACLE SELECT LEVEL FROM DUAL CONNECT BY LEVEL
TIL/db 2022. 10. 4. 17:16
MySQL) date_format

DATE_FORMAT(date, format) - date : 날짜 형식을 지정할 date 데이터 - format : 날짜 형식 ** format format description %a This abbreviation means weekday name. It’s limit is from Sun to Sat. %b This abbreviation means month name. It’s limit is from Jan to Dec. %c This abbreviation means numeric month name. It’s limit is from 0 to 12. %D This abbreviation means day of the month as a numeric value, followed by suff..
TIL/db 2022. 10. 4. 16:03
MySQL) MIN, MAX 값 구하기

- MIN(), MAX() 함수를 통해서 구하기 -- min SELECT MIN(Price) AS SmallestPrice FROM Products; -- max SELECT MAX(Price) AS LargestPrice FROM Products; - ORDER BY 를 통해서 구하기 -- min SELECT * FROM SmallestPrice ORDER BY Price ASC LIMIT 1; -- max SELECT * FROM LargestPrice ORDER BY Price DESC LIMIT 1; ** limit n (, m) - m 값이 없는 경우 : 0번째부터 n개 오름차순/내림차순 출력 - m 값이 있는 경우 : n번째부터 m개 오름차순/내림차순 출력 - where 절을 통해서 구하기 -..
TIL/db 2022. 10. 4. 15:51
이전 Prev 1 Next 다음