skip to Main Content

Mysql – how to add a temporary coloum for sql query

i have a sql query for summary my table, $this->where('kriteria =', 'fakir'); $this->where('zona !=', '0'); $this->select('surveyor,zona,kriteria,area'); $this->selectCount('surveyor', 'count'); $this->selectSum('nilai', 'nilai'); $this->groupBy('surveyor'); $this->groupBy('kriteria'); $this->groupBy('area'); $this->orderBy('kriteria', 'ASC'); $this->orderBy('zona', 'ASC'); $this->orderBy('count', 'DESC'); surveyor zona kriteria area COUNT RT06 RW07 1 FAKIR RUNGKUT 125…

VIEW QUESTION
Back To Top
Search