NiceMan331
asked on
how can select * and calculated filed
hi
if i have table mytable has more than 20 fields , including
debit number
credit number
how i can select *,(debit - credit) balance from mytable
if i have table mytable has more than 20 fields , including
debit number
credit number
how i can select *,(debit - credit) balance from mytable
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
SELECT m.*, SUM(m.debit_number), SUM(m.credit_number)
FROM mytable m
GROUP BY m.USE_ONE_ID_Column