Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to get count of records group by a column

kankvats1
Level 1
Level 1

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

1 Accepted Solution
gunnark17854189
Correct answer by
Level 2
Level 2

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

View solution in original post

2 Replies
gunnark17854189
Correct answer by
Level 2
Level 2

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

View solution in original post

Sukrity_Wadhwa
Employee
Employee

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!