New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Sql] 가격이 제일 비싼 식품의 정보 출력하기 #219

Closed

hwangJi-dev opened this issue Apr 27, 2023 · 0 comments

Assignees

Labels

level2 sql 프로그래머스

Owner

hwangJi-dev commented Apr 27, 2023 •

edited

Loading

`💬 문제`

https://school.programmers.co.kr/learn/courses/30/lessons/131115

`💬 Idea`

서브쿼리로 가격이 제일 비싼 것을 찾아내 조건으로 걸어준다!

`💬 풀이`

SELECT *
FROM FOOD_PRODUCT
WHERE PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT)

The text was updated successfully, but these errors were encountered:

hwangJi-dev added 프로그래머스 level2 sql labels

hwangJi-dev self-assigned this

hwangJi-dev closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment