CREATE TABLE [dbo].[PARAM_PROJ_CATE] (
[id] varchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL,
[parent_id] varchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL,
[lvl] varchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL,
[cate_name] varchar(100) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK__PARAM_PR__3213E83FA4DCAAB4] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)
ON [PRIMARY]
)
ON [PRIMARY]
GO
这样的一个 sqlserver 表结构，怎么样查询所有叶子节点 求大神支招

SELECT* FROMPARAM_PROJ_CATE
WHEREid NOT IN (SELECTparent_id FROMPARAM_PROJ_CATE)
有没有比这个简单的