We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
My answer in MySQL. I have to keep track of row number of each Occupation for pivoting. Using either max()/min() can get first non-null value after group by.
Occupations
You are viewing a single comment's thread. Return to all comments →
My answer in MySQL. I have to keep track of row number of each Occupation for pivoting. Using either
max()
/min()
can get first non-null value aftergroup by
.