728x90
반응형
mysql
-
14주차 금 1124(데이터 분석, 조인관련..)광주인력개발원 일일포스팅(메모장) 2023. 11. 24. 16:45
-- [문제] /* - 회원아이디 b001 회원 마일리지값보다 큰, - 회원정보 조회하기 - 조회컬럼 : 회원아이디, 이름 */ SELECT mem_id, mem_name, mem_mileage FROM member WHERE mem_id = 'b001' ; SELECT A.mem_id, A.mem_name FROM member A, (SELECT mem_id, mem_name, mem_mileage FROM member WHERE mem_id = 'b001') B WHERE A.mem_mileage > B.mem_mileage; -- 다른방법 SELECT mem_id, mem_name FROM member WHERE mem_mileage > (SELECT mem_mileage FROM member WH..