This should work: SELECT requestID, OrderNum, SalesName FROM tHWRequestApprover a where OrderNum = ( select max(b.OrderNum) from tHWRequestApprover b where b.requestID= a.requestIDgroup by b.requestID)
Regards, Vibha > ----- Original Message ----- > From: Next Step <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, February 23, 2002 9:41 AM > Subject: Re: SQL statement. > > > > 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 > =========================================================================== 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
