can you explain what meaning of hard code query? i'm newbie like this query:

Query :

SUM(case when motor='vario' then 1 else 0 end) vario,
SUM(case when motor='beat' then 1 else 0 end) beat,
SUM(case when motor='supra'then 1 else 0 end) supra,
SUM(case when motor='megapro'then 1 else 0 end) megapro,
SUM(case when motor='cb150'then 1 else 0 end) cb150
FROM matrixreport
GROUP by Nama;

Is it hard code?


Your code seems working well. In software development, "hard code" or "hard coding" can be interpreted as "embedding your external data like SQL statement directly to your source code".


Hard coding

Soft coding

Not the answer you're looking for? Browse other questions tagged or ask your own question.