count different value in sql

Question

I try to count a data with integer datatype in a table

I used the query below

SELECT sesi_ujian,hari_ujian,COUNT(DISTINCT sesi_ujian) AS jumlah FROM ujian_mhs

It works, but return 1 result like this

and in my table, there are 5 different "sesi_ujian" values, such as :

can you tell me how to display the counting result of "sesi_ujian" ?

reza · Accepted Answer · 2016-12-28 05:07:05Z

1

your SQL for it, is wrong. try following

SELECT DISTINCT sesi_ujian,hari_ujian,COUNT(id) AS jumlah FROM ujian_mhs group by sesi_ujian

answered Dec 28, 2016 at 5:07

reza

1,5072 gold badges12 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Afiz · Accepted Answer · 2016-12-28 05:10:24Z

0

If you are looking for only distinct values count. Use the below query.

SELECT COUNT(DISTINCT sesi_ujian) FROM ujian_mhs

answered Dec 28, 2016 at 5:10

Afiz

5131 gold badge4 silver badges14 bronze badges