Hello all -
I am trying to limit the results of a query using the LIMIT clause - but instead of an absolute number I would like to limit by a percentage of rows returned.
It seems the LIMIT clause only supports absolute numbers. Any ideas greatly appreciated.
TIA,
BGH
PS - The analogous syntax in Access is "SELECT TOP n PERCENT" which returns the top n percent of rows ordered by ORDER BY.
