If you want to find the last five records, you will *have* to use a condition to define which they are. Remember that there is no defined order in a relational database, you must specify one when you require one. If you mean the five records most recently entered you will need to store the entry date in the record, you can then use it to find the most recent records.
HTH John ----- Original Message ----- From: "Priti Chhetri" <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 11:53 AM I need to take out last 5 records from the table and without using any condition and then I have display highest salary from retrieved Records in JSP as I have one column as Salary .(using Oracle ).Quick answer would be very much helpful =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
