Let's say that we have the following table. What will be the expression to find minimum and maximum values of the "First" column but only for rows 3 to 8 and return also the values which are located on the column named "Second" next to the maximum and minimum.
For example, in the following table minimum value within range 3 to 8 is 123 and maximum is 960. The values next to minimum and maximum are 103 and 108 accordingly. So values 123, 103 and 960, 108 must be returned.
First Second Rows
321 101 1
412 102 2
123 103 3
543 104 4
431 105 5
432 106 6
323 107 7
960 108 8
423 109 9
752 110 10
Bookmarks