select requestID from trequest where ordernum=max(ordernum); This assumes that by highest you mean the highest alphabetically.
Clayton ----- Original Message ----- From: "Next Step" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 12:50 PM Subject: OOT: SQL statement. > Hi, > > I have one table, say TRequest which has : > > UID RequestID OrderNum SalesName > ----+-----------+-----------+------------ > 1001 REQ1 1 III > 1002 REQ2 1 UUU > 1003 REQ2 2 TTT > 1004 REQ3 1 XXX > 1005 REQ4 1 XYZ > 1006 REQ4 2 WWW > 1007 REQ4 3 UUU > 1008 REQ4 4 CCC > > How to retrieve *only* one RequestID which has the *highest* OrderNo in one > statement? > Right now I'm retrieving all and do procesing/filtering in jsp, which i > think is not so efficient. > > Tks. > > =========================================================================== > 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
