Problems i faced in mysql query
one day i was working on Race project where director can payment online and manually .
I had been stored all Amount in one column "amt".
take a look on below image
I was want SUM of manual payment , electronic payment and total of all payment in one query. That day i had been write following query by using Mysql SUM() function and conditional CASE statement.
Here...
