Home > database > Figure 1 how to query the occurrences of values in a column in column b, and finally get the result
Figure 1 how to query the occurrences of values in a column in column b, and finally get the result
Time：01-17
SELECT ta. A, (SELECT count (*) FROM ` table ` WHERE b=ta. A) as the dd FROM ` table ` as ta I use the above this sentence can be found out, but it seems a little silly, want to ask is there any better writing
