At 09:13 AM 2/23/2002 +0700, you wrote: >At 01:43 PM 2/21/2002 -0500, you wrote: >>Try this: >> >>SELECT RequestID FROM TRequest >>WHERE OrderNum = (SELECT MAX(OrderNum) FROM TRequest); > >It will only retrieve *one* record which has highest OrderNum. >What i want is to retrieve *every* unique RequestID which has highest >OrderNum, say for REQ1 return Ordernum 1, REQ4 return 4. >Sorry if its not clear.
It should be something like : SELECT requestID, MAX(OrderNum) FROM tHWRequestApprover GROUP BY requestID But from above query, i can not obtain SalesName which is required. Any hints? TIA. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
