...

View Full Version : Sql max query



ROYW1000
07-02-2011, 11:42 AM
Hi

I normally use MySQL but have a query issue with SQL and wondered if anyone knows how to work it.

I have a table called ODBC_ORDER_ALL and I need to generate a report of the account number and last order date.

This table contains all orders for about 10 years by account number so I just need the unique account number and the last order date to come out.

Table: ODBC_ORDER_ALL

Field 1: ORDER_ACCOUNT_ID
Field 2: ORDER_DATE

Thanks in advance for you help.

Roy

Fugix
07-02-2011, 07:57 PM
are you trying to simply display the data from your table?

MattF
07-03-2011, 05:25 PM
Check the manual for the GROUP BY statement.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum