I have a table with 4 columns as mentioned below.
I would be firing a query with where condition as "Commission = 0" now the Perks column should appear if there is any value in that, otherwise it should not appear.
FYI, at any given time, i would get only one record / one row as result set. I might be interested to know the name and designation along with Perks if it is NOT NULL
Thanks for reading
Every thing is perfect as long as you share
View Complete Post