How to get count of records group by a column | Adobe Higher Education
Skip to main content
K
kankvats1
February 9, 2021
Risolto

How to get count of records group by a column

  • February 9, 2021
  • 2 risposte
  • 2578 visualizzazioni

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

Questo argomento è stato chiuso alle risposte.
Migliore risposta di gunnark17854189

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

2 risposte

G
gunnark17854189Risposta
Level 2
February 10, 2021

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

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    February 15, 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!  

    Sukrity Wadhwa
    Termini e CondizioniAccessibility statement

    Loading footer...