Well you are going to have to use group by and a decode statement. You want the actual sql statement why do u not go ask someone in a sql group.
but something like SELECT MAX(OrderNum),requstID FROM TRequest group by requestID,OrderNum might work. dont know if this works but hey did it in 10 secs ----- Original Message ----- From: "Next Step" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 9:13 PM Subject: Re: SQL statement. > 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. > > 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 > =========================================================================== 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
