|
-
Select most recent record
I need to select the most recent record for a work order (identified by WOP_WO_ID)
with who is assigned to the action (identified by WOP_WHO). Sample data is
below.
WOP_ID WOP_WO_ID WOP_DATE WOP_WHO WOP_ACTION
34333 5431 22-JAN-2001 10:22 203 Action sdkk
34334 5431 23-JAN-2001 11:10 256 Action kj9 n984j
34335 5431 24-JAN-2001 09:07 223 Action 234ff3
34336 5532 24-JAN-2001 08:43 298 Action vrf3
34337 5532 24-JAN-2001 09:54 209 Action 54f3
The result I need is:
WOP_WO_ID WOP_DATE WOP_WHO
5431 24-JAN-2001 223
5532 24-JAN-2001 209
How do I do it?
Thanks all.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks