Date:03.11.2016, 20:15 When you have this requirement the TOP clause has you covered. To dynamically return the top number of rows you just need to use an expression in the TOP clause. The expression just needs to return the number of rows that you dynamically want to return. If you use the TOP clause with the no additional options it will only return three rows. But what if you want return that fourth row because it has the same value as the third row for the ordered set? Therefore this code could return anywhere from 1 to 12 rows depending on which month the SELECT statement is run. Using the Percentage value with the TOP Clause Are there times when you want to return some percentage of rows within a table? When you have this requirement you can use the PERCENT option. To demonstrate this review the code below: SELECT TOP(13) PERCENT FROM les ORDER BY SalesAmount DESC ; When I run this code it returns the following rows: SalesID SalesDate Region SalesAmount SouthWest 1012.31 5 NorthWest 400.78 In this example, I specified that I wanted to return 13 percent of.