Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
try this. just modify the query and join the needed tables.SELECT Regno, Sname, Class, Section,SUM(CASE WHEN FeeType = 'Jan' THEN Amount ELSE 0 END) AS Jan,SUM(CASE WHEN FeeType = 'Feb' THEN Amount ELSE 0 END) AS Feb,SUM(CASE WHEN FeeType = 'Mar' THEN Amount ELSE 0 END) AS...
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Submit an article or tip
