Link to home
Start Free TrialLog in
Avatar of NiceMan331
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
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kanti Prasad
Kanti Prasad

Hi

Try

SELECT m.*, SUM(m.debit_number), SUM(m.credit_number)
FROM    mytable m
GROUP   BY m.USE_ONE_ID_Column