SELECT MAX (company) FROM Sales WHERE net_amount > 100; The MAX function is sometimes used on columns containing an auto-incremented key field to determine what the next entry’s key ID will be.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

-- The SELECT statement is used to select data from a database. -- The data returned is stored in a result table, called the result-set. -- SELECT Syntax: SELECT column1, column2, ... FROM table_name; ...