SELECT @curRow := @curRow + 1 AS nomor_urut, trx.jenis_transaksi, trx.id_matauang, trx.total_transaksi FROM hc_transaksi trx JOIN (SELECT @curRow := 0) r
Hasilnya sebagai berikut :
SELECT @curRow := @curRow + 1 AS nomor_urut, trx.jenis_transaksi, trx.id_matauang, trx.total_transaksi FROM hc_transaksi trx JOIN (SELECT @curRow := 0) r