Hey there,
I'm struggling to retrieve the count amount of my sql query via Java.
What I wan't to do, is to show the counted amount of a row in the title.
Help is appreciated!
Hey there,
I'm struggling to retrieve the count amount of my sql query via Java.
What I wan't to do, is to show the counted amount of a row in the title.
Help is appreciated!
use SUM(count(status) and remove group by clause
I think in your query, you want to fetch the status as well
select status, count(*) from sessions
group by status
order by status
Then for each status (Scheduled, Preparation, etc.), you can display the value based on your count corresponding to that status, e.g. {{ query5.data.count[0] }}