oracle how to identify the last entry of the each item

Reply

•
•
Join Date: Nov 2008
Posts: 1
Reputation: ssmdesai is an unknown quantity at this point 
Solved Threads: 0
ssmdesai ssmdesai is offline Offline
Newbie Poster

oracle how to identify the last entry of the each item

 
0
  #1
Nov 28th, 2008
In a table containing records of all customer with there orders and status of deliveries. Now I wish to find only last the entry of each customer available this table, it can be their last order or delivery status. What would be the ideal query for this? Please help me.
Last edited by ssmdesai; Nov 28th, 2008 at 3:16 am.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,139
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 132
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: oracle how to identify the last entry of the each item

 
0
  #2
Dec 1st, 2008
do you store the order datatime as well ?
Share your Knowledge.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the Oracle Forum


Views: 757 | Replies: 1
Thread Tools Search this Thread



Tag cloud for Oracle
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware erp federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC