컴퓨터 프로그래밍 컴퓨터 프로그래밍

SQL

• CONNECT BY

  SQL 2020. 7. 3. 17:33

  SELECT LPAD(' ', 3 * LEVEL - 3) || ename NAME, LEVEL, empno, mgr FROM emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr;

  Read More
• SELECT

  SQL 2012. 3. 12. 11:11

  Microsoft SQL Server SELECT TOP 10 column FROM table PostgreSQL and MySQL SELECT column FROM table LIMIT 10 Oracle SELECT column FROM table WHERE ROWNUM

  Read More