TIL - 250205

리뷰 : 윈도우 함수를 다시 재검토하는 시간을 가졌다. 추가로 LIMIT와 함께 쓰이는 OFFSET에 대해 알게 되었다.

URL : https://datalemur.com/questions/total-drugs-sales

SELECT 
  manufacturer
  ,CONCAT('$',ROUND(SUM(total_sales)/1000000),' million')
FROM pharmacy_sales
GROUP BY 1
ORDER BY SUM(total_sales) DESC
;

URL : https://datalemur.com/questions/sql-second-highest-salary

SELECT
  salary
FROM (
SELECT salary
FROM employee
ORDER BY salary DESC
LIMIT 2
) a
ORDER BY salary
LIMIT 1
;

SELECT salary
FROM employee
ORDER BY salary DESC
LIMIT 1 OFFSET 1;