Why this query is showing multiple result

[Arun Mahajan]

Why the following query gives multiple rows

SELECT
IF(ISNULL(trim(insured_ecard_path)), 'NULL', 'NOT NULL') as value,
COUNT(*)
FROM hrms_medical_gmc
where cmpcode='AT161'
GROUP BY insured_ecard_path

NOT NULL
4
NOT NULL
4
NOT NULL
4
NOT NULL
3
NOT NULL
5
NOT NULL
4
NOT NULL
6
NOT NULL
3
NOT NULL
4
NOT NULL
4
NOT NULL
4
NOT NULL
4
NOT NULL
4
NOT NULL
3
NOT NULL
2
NOT NULL
4
NOT NULL
5
NOT NULL
6
NOT NULL
5
NOT NULL
5
NOT NULL
5
NOT NULL
5
NOT NULL
4
NOT NULL
3
NOT NULL

 

[feherke]

Hi

Probably because the [tt]group by[/tt] clause results that many distinct values. Maybe you want [tt]group by value[/tt] instead ?


Feherke.
feherke.github.io