-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 SELECT * FROM TRequest WHERE UID = MAX(UID)
Branden Root Web Developer Portent Interactive [EMAIL PROTECTED] - -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Next Step Sent: Thursday, February 21, 2002 4:51 AM To: [EMAIL PROTECTED] 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 -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPHUjQ7Uu6h7/IdroEQJJHwCg4RpcMB6idyLCsffeq4pfS3t1v+8Amwd2 SDLlDgMPttOF3CVhsWUmCtAp =HFsW -----END PGP SIGNATURE----- =========================================================================== 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
