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.

(If your select statement is merely necessary to determine if you should do an update or not, it should just be returning a single value and not any data at all).<BR><BR>3.

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?<BR><BR>Thanks,<BR><BR>Pete ...