I have a question on selecting top N rows for a data set. I understand I can use TOP N rows from Sample tile to select number of rows I want but what I am looking for is something dynamic.
Here is the sample data set. Data has been grouped by the field Number and ranked accordingly. However I from each group of unique Number I need to select only half rows. If the number of rows is N and for a group of N is even I need to select First N/2 rows if N is odd then first N/2+1 rows.