General information
Title:
Result without group by
Dear Experts
I have table1, containing data as follows
month pen pencil book
jan 15 20 35
feb 27
feb 37 16
mar 5 7 98
apr 47
apr 46
apr 45
In table1, month feb and apr comes more than one times. If a month comes more than one times then data of other records of the same month should come in first occourance in related fields. I do not want to use command like select sum(pen). The result should look this
month pen pencil book
jan 15 20 35
feb 37 27 16
mar 5 7 98
apr 45 46 47
Please help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only