As i was looking for the exact same thing and have found your question, i will answer on this, even if it's surely a bit too late for you...
I've found a way to achieve this using concat and subfield functions.
subfield(concat(SALES,';',-SALES),';',2) as SecondBestSales (Non distinct)
RESIDENT myTable GROUP BY PRODUCT;
I hope it can help other people,