SQL parent statistics itself and the number of children, child statistics itself-CodePudding

Home > database > SQL parent statistics itself and the number of children, child statistics itself

SQL parent statistics itself and the number of children, child statistics itself

Time：11-13

Binhai new area is tianjin tanggu subsidiaries of the parent, ORGID2 is parent, branch ORGID2 is itself, is the parent of branch, field ORGDEGREE: branch branch, subbank - 2 branches, now want to find out the binhai new area branch COUNT1=6, count2=0, count3=2, count4=0, tianjin tanggu branch data remains the same,
Please everyone a great god help to look at, the younger brother have plagued the two days,,,,,,, turn to for help

Page link：https//www.codepudding.com/database/80968.html

Prev:SQL injection problem (oracle)

Next:To sort the query by the top in the day, the rest of the fourth in according to the date of order

Tags：

MySQL

Links：
CodePudding