Set-Based Operations

SQL is set-based rather than row-based. Instead of looping through individual rows, SQL handles groups (or sets) of rows at once. For example, finding the average salary of all employees takes just one query using AVG().

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *