728x90 반응형 SMALL 전체 글430 Hackers Rank : SQL Oracle : Type of Triangle solution # Q Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with sides of equal length. Isosceles: It's a triangle with sides of equal length. Scalene: It's a triangle with sides of differing lengths. Not A Triangle: The given values of A, B, and C don'.. 2022. 6. 2. 오라클 서브 쿼리 연습 Oracle Subquery practice 1. 사원번호가 7788인 사원과 담당 업무가 같은 사원을 표시 SELECT ENAME, JOB FROM EMPLOYEE WHERE JOB = (SELECT JOB FROM EMPLOYEE WHERE ENO=7788); 2. 사원번호가 7499인 사원보다 급여가 많은 사원을 표시 SELECT ENAME, JOB FROM EMPLOYEE WHERE SALARY > (SELECT SALARY FROM EMPLOYEE WHERE ENO=7499); 3. 최소 급여를 받는 사원의 이름, 담당업무, 급여 표기 SELECT ENAME, JOB, SALARY FROM EMPLOYEE WHERE SALARY = (SELECT MIN(SALARY) FROM EMPLOYEE); 4. 평균 급여가 가장 적은 사원의 담당업무.. 2022. 6. 1. 테이블 조인 연습하기 OracleTable Join practice # TABLE JOIN PRACTICE (ANSWERS NEED TO BE SET THE BLOCK) 정답을 블록 설정으로 확인 1. EQUI 조인 사용하여 SCOTT 사원의 부서번호와 부서이름을 출력 SELECT E.ENAME, D.DNO, D.DNAME FROM EMPLOYEES E, DEPARTMENT D WHERE E.DNO = D.DNO AND E.ENAME = 'SCOTT'; 2. INNER JOIN과 ON 연산자를 사용하여 사원이름과 함께 그 사원이 소속된 부서이름과 지역명을 출력 SELECT ENAME, DNAME, LOC FROM DEPARTMENT D JOIN EMPLOYEE E ON E.DNO = D.DNO; 3. INNER JOIN과 USING 연산자를 사용하여 10번 부서에 속하는.. 2022. 6. 1. Hackers Rank : SQL Oracle : Weather Observation Station 5 solution # Q Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. # A SELECT CITY, LENGTH(CITY) FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY) WHERE ROWNUM=1; SELECT CI.. 2022. 6. 1. 이전 1 ··· 98 99 100 101 102 103 104 ··· 108 다음 728x90 반응형 LIST