I am trying to use select by attribute for the table which is similar to the following picture (lets say):
ID countA 3A 8 A 12B 2 B 9B 22
I want to select those entries for each A and B, which have maximum count.
I usedSELECT * FROM table WHEREcount=(SELECT DISTINCT MAX(count) FROM table)
This can give result for the maximum count of the whole table. What should be the modification or addition in the above query so that it will select the maximum count for A and B as well?
أكثر...
ID countA 3A 8 A 12B 2 B 9B 22
I want to select those entries for each A and B, which have maximum count.
I usedSELECT * FROM table WHEREcount=(SELECT DISTINCT MAX(count) FROM table)
This can give result for the maximum count of the whole table. What should be the modification or addition in the above query so that it will select the maximum count for A and B as well?
أكثر...