Why might you leverage the PARTITION BY clause in your query?

Why might you leverage the PARTITION BY clause in your query?

 

• Partition a table into new sub-tables based on a specified column
• Limit records in the result set to the partition’s date range
• Divide the result set into partitions based on the specified column