If employees gonghaowu, there are many departments in a table, a division 1 down since, under a department is downwards on the 1, with a select into can realize it

CodePudding user response:

Ok row_number () over (partition by department order by... )

CodePudding user response:

Grouping by department on the,
Partition by [sector]