I am trying to create a query that pulls back groupings of the fixed percents. Basically I am creating "Rankings" for the fixed percentages.
I have a table built. It has roughly 4,000 rows. It has 20 columns, and I want to pull back something like this:
SELECT Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9 Column10 Column11 Column12 Column13 Column14 Column15 Column16 Column17 Column18 Column19 Column20 TOP 2 PERCENT Column2 AS Super High TOP 8 PERCENT Column2 AS High FROM DATABASE 1
Any thoughts? I can't seem to think of a way to go about doing this.