728x90 전체 글166 [ Oracle ] 조건별로 우선 정렬하기 ORDER BY DECODE/CASE 조회 쿼리를 이용 할 때, 단순히 오름차와 내림차순 정렬이 아니라 정렬을 하되 우선적인 값을 제일 상단에 조회하고 그 후 정렬을 하던지 등 원하는 특정 조건을 기준으로 잡아 정렬을 해야하는 경우가 있다. 방법은 그리 복잡하지 않으니 예제를 보면서 이해해보도록 하자. 먼저 아래와 같은 주문테이블이 있다고 가정한다. CREATE TABLE 주문테이블 ( 주문일자 VARCHAR2(200 BYTE), 주문상품 VARCHAR2(200 BYTE), 주문상태 VARCHAR2(200 BYTE) ); INSERT INTO 주문테이블 (주문일자, 주문상품, 주문상태) VALUES ('2021-01-20', '삼겹살' , '배송중' ); INSERT INTO 주문테이블 (주문일자, 주문상품, 주문상태) VALUES ('20.. 2022. 4. 29. [AZ-104] 덤프 문제 - 5 (Dump Quiz -5) 41. You have an Azure subscription named Subscription1 that contains an Azure virtual machine named VM1. VM1 is in a resource group named RG1. VM1 runs services that will be used to deploy resources to RG1. You need to ensure that a service running on VM1 can manage the resources in RG1 by using the identity of VM1. What should you do first? A. From the Azure portal, modify the Managed Identity .. 2022. 4. 22. [AZ-104] 덤프 문제 - 4 (Dump Quiz -4) 21. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these question.. 2022. 4. 22. [AZ-104] 덤프 문제 - 3 (Dump Quiz -3) Question Set 2. 1. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result,.. 2022. 4. 22. 이전 1 ··· 8 9 10 11 12 13 14 ··· 42 다음 728x90
