How can I write a query to get the result below from the sample data given?
Data in table EMP is as below:
Empid Empname Sal Comm 100 ABC Null 20 100 ABC 20000 null
Output should be:
Empid Empname Sal Comm 100 ABC 20000 20
closed as off-topic by ypercube, David Spillett, JNK♦ Apr 10 '14 at 14:51
This question appears to be off-topic. The users who voted to close gave this specific reason: