sql 递归

CREATE TABLE [dbo].[employees](
    [employeeid] [int] NOT NULL,
    [managerid] [int] NULL,
    [employeename] [char](10) NOT NULL,
    [salary] [money] NOT NULL
) ON [PRIMARY]

数据：

employeeid    managerid    employeename    salary
1    NULL    a1            10000.00
2    1    b1            9000.00
3    1    b2            9000.00
4    2    c1            9000.00
5    2    c2            8000.00
6    3    c3            8000.00

sql 递归

标签：log   执行   mon   数据   report   level   成员   null   font