tree(2)
-
[ORACLE] 계층형 구조에서 최하위 항목 출력
SELECT *FROM DEPT_INFOWHERE CONNECT_BY_ISLEAF = 1 AND CONNECT_BY_ISCYCLE = 0START WITH PARNTS_DEPT_CD = '00000000'CONNECT BY NOCYCLE PRIOR DEPT_CD = PARNTS_DEPT_CD;
2018.10.26 -
트리구조 쿼리문
CREATE TABLE [dbo].[tblcommon]( [SEQ] [int] IDENTITY(1,1) NOT NULL, [GUBUN] [varchar](30) NOT NULL, [TITLE] [varchar](150) NOT NULL, [DEPTH] [int] NOT NULL, [PARENT_SEQ] [int] NULL, [SORT] [int] NOT NULL, CONSTRAINT [PK_tblcommon] PRIMARY KEY CLUSTERED ([SEQ] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ..
2015.04.23