Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
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 | 31 |
Tags
- JSP
- ์ฝํ
- ์๋ฐ์คํฌ๋ฆฝํธ
- MySQL
- ํจ์
- like
- ๋์
- Spring
- ๋ฐฐ์ด
- SQL
- order by
- ๋ฆฌ๋ ์ค
- optionํ๊ทธ
- ์ธ๋ผ์ธ๋ทฐ
- select
- ์ปจํธ๋กค๋ฌ
- ๋์ ํ ์ด๋ธ
- DATE_FORMAT
- Update
- ๋ณ์
- ๋์ปค
- JS
- ํ ์ด๋ธ
- JavaScript
- ํ๋ก๊ทธ๋๋จธ์ค
- oracle
- post๋ฐฉ์
- ๋ช ๋ น์ด
- Ajax
- ๋ฐฑํฑ
Archives
- Today
- Total
bom's happy life
[SQL ์ฝํ ] ๊ฐ์ฅ ๊ฐ๊ฒฉ์ด ๋น์ผ ๋ฌผ๊ฑด SELECT(์ง๊ณํจ์ ์ฌ์ฉํ๊ธฐ) ๋ณธ๋ฌธ
Algorithm๐/ํ๋ก๊ทธ๋๋จธ์ค
[SQL ์ฝํ ] ๊ฐ์ฅ ๊ฐ๊ฒฉ์ด ๋น์ผ ๋ฌผ๊ฑด SELECT(์ง๊ณํจ์ ์ฌ์ฉํ๊ธฐ)
bompeach 2023. 8. 10. 11:17Q)
FOOD_PRODUCT ํ ์ด๋ธ์์ ๊ฐ๊ฒฉ์ด ์ ์ผ ๋น์ผ ์ํ์ ์ํ ID, ์ํ ์ด๋ฆ, ์ํ ์ฝ๋, ์ํ๋ถ๋ฅ, ์ํ ๊ฐ๊ฒฉ์ ์กฐํํ๋ SQL๋ฌธ์ ์์ฑํด์ฃผ์ธ์.
MYSQL
A1)
--MYSQL
SELECT *
FROM FOOD_PRODUCT
ORDER BY PRICE DESC
LIMIT 1
;
์ผ์ผ์ด ๋ค ์ธ ํ์์์ด * ํด์ฃผ๋ฉด ๋๋ค.
ORACLE
A1)
--ORACLE
SELECT *
FROM FOOD_PRODUCT
ORDER BY PRICE DESC
FETCH FIRST 1 ROWS ONLY;
A2)
--ORACLE
SELECT PRODUCT_ID,PRODUCT_NAME,PRODUCT_CD,CATEGORY,PRICE
FROM (SELECT *
FROM FOOD_PRODUCT
ORDER BY PRICE DESC
)
WHERE ROWNUM=1;
'Algorithm๐ > ํ๋ก๊ทธ๋๋จธ์ค' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[SQL ์ฝํ ] ๊ณผ์ผ๋ก ๋ง๋ ์์ด์คํฌ๋ฆผ ๊ณ ๋ฅด๊ธฐ (0) | 2023.08.11 |
---|---|
[SQL ์ฝํ ] 3์์ ํ์ด๋ ์ฌ์ฑ ํ์ ๋ชฉ๋ก ์ถ๋ ฅํ๊ธฐ (0) | 2023.08.11 |
[SQL ์ฝํ ] ์กฐ๊ฑด์ ๋ง๋ ํ์์ ๊ตฌํ๊ธฐ (0) | 2023.08.10 |
[JAVA] ์๋ฌธ์๋ก ๋ฐ๊พธ๊ธฐ (0) | 2023.04.28 |
[JAVA] ๋ฌธ์ ๋ฆฌ์คํธ๋ฅผ ๋ฌธ์์ด๋ก ๋ณํํ๊ธฐ (0) | 2023.04.28 |