We need an Oracle expert to help us,
We have data a table
ID, VENDOR, MODEL
2, Platform, N71
3, Generic, S60
we need an select statement that will return 1 row with the followin information
because Nokia is the first non null value for column VENDOR and N71 is the first non null value for column MODEL.
Our table contains 9000 rows, and 55 columns, but in basic the select statement we need to be able to deliver the above result.
Can that be done, and how?