Home » SQL & PL/SQL » SQL & PL/SQL » Query Issues
icon8.gif  Query Issues [message #199357] Mon, 23 October 2006 14:50 Go to next message
Messages: 4
Registered: October 2006
Location: TEXAS
Junior Member
Hello Guys,
I want to show the date_received and the total number of shipment received on each date from the SHIPMENT_LINE table sorted with the most recent date_received first
I kept getting argument error.

Any ideas?
Re: Query Issues [message #199365 is a reply to message #199357] Mon, 23 October 2006 16:34 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What argument?
SELECT date_received, SUM(shipment_received)
FROM shipment_line
GROUP BY date_received
ORDER BY date_received DESC;
Previous Topic: Analytical Function MAX
Next Topic: Unique Keys per table
Goto Forum:

Current Time: Fri Aug 18 00:15:16 CDT 2017

Total time taken to generate the page: 0.10099 seconds