Selecting the Top 10% of Rows — Teaching Tech Tools

Selecting the Top 10% of Rows

We can even specify the TOP 10% of rows to return to see which records would be returned in that resulting dataset:

SELECT TOP(10) PERCENT

FROM database_table

ORDER BY 2022 estimate DESC

Now, if the full dataset had 100 rows, only the top 10 rows would be returned, up until Austin.
Using the PERCENT keyword in sub-queries is extremely valuable and is explored further in Advanced SQL queries.