max query expression
have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?
Software/Hardware used:
access 2003
Software/Hardware used:
access 2003
ASKED:
Feb 14, 2012 2:51 PM GMT
UPDATED:
February 27, 2012 8:42:18 PM GMT
RELATED QUESTIONS
- Updating a table with sub query
- Oracle PL/SQL "Toad for Oracle" converting a query to a function
- Migrating from MS Access to SQL Server Express
- File conversion
- How can i express the percent margin in a query for Microsoft Access?
- SQL Query Perfomance Issue.
- Oracle- Source Code for Tables and Views cannot find
- how to upgrade server to SQL 2005
- SQL Express 2005 query times lagging
- SQL Server 2005 Express issue...
Answer Wiki:
You would have to use the MAX function
60,255 pts.
To see other answers submitted to the Answer Wiki View Answer History.
