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.

-- 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; ...

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 ...