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
