How to find the 3 highest values and the 3 lowest values?
Hello,
I have an attribute called price. I want to find the 5 highest values and 5 lowest (e.g if my column contains prices 1,2,3,4,5,6,7,8,9,10,11) this should give me 1,2,3,9,10,11. I hope I am being clear enough. Now I know how do do this seperately by sorting and filtering, I cant seem to find a way to generate this in one go.
Please help. Please go easy on me as I am a newbie