How to get count of records group by a column

Avatar

Avatar

kankvats1

Avatar

kankvats1

kankvats1

09-02-2021

Hi ,

 

Could some one help to use the aggregate function count to get number of rows based on one particular column. For e.g something like below corresponding to sql.

 

select count(1),testcolumn from testtable group by testcolumn .

so i can get the records liks as below:

test1 100

test2 200

test3 300

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

15-02-2021

Hi @kankvats1,

Were you able to resolve this query with the given solution or do you still need more help here? Do let us know.

Thanks!  

Avatar

Avatar

gunnark17854189

Avatar

gunnark17854189

gunnark17854189

10-02-2021

Bildschirmfoto 2021-02-10 um 14.27.54.png

you can do a query and then click on "group". You also check the box to Advanced parameters