Suggestions intermixed with your questions below. However, because you
only described your table and neglected to post the actual CREATE TABLE
statement, I will need to make a few assumptions (the actual name of your
table and the fact that missing data is stored as nulls are two I can
think
hello,
Example : i hv a table containg date, flower, perfume,codeno,regno etc
There are some row which have only flower entries for a day. there are
some rows which have only perfume entries for a day.
some rows have both florwer and perfume entries for a day..ie same day
contains both