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
fmbamalu
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
Littlefoot
Messages: 20894
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: Mon Dec 05 08:32:13 CST 2016

Total time taken to generate the page: 0.12873 seconds