نوشته شده توسط
mehdi4467
متوجه نشدم.
SELECT trakonesh.tr_id, trakonesh.tr_bedehkar, trakonesh.tr_bestankar, trakonesh.tr_date_miladi, trakonesh.tr_bestankar-trakonesh.tr_bedehkar AS Expr1
FROM trakonesh
ORDER BY trakonesh.tr_date_miladi;
-----------------------------------------------------------------------------------------------------
| tr_id | tr_bedehkar | tr_bestankar | tr_date_miladi | Expr1 |
-----------------------------------------------------------------------------------------------------
| 88 | 0 | 100 | 9/01/2010 | 100 |
-----------------------------------------------------------------------------------------------------
| 87 | 450 | 0 | 9/01/2010 | -450 |
-----------------------------------------------------------------------------------------------------
| 86 | 200 | 0 | 9/01/2010 | -200 |
-----------------------------------------------------------------------------------------------------
| 85 | 0 | 2000 | 9/01/2010 | 2000 |
-----------------------------------------------------------------------------------------------------