Hi Priti, You can execute following query from your JSP
Select Salary from tablename where rownum<=5 order by salary desc; This will first arrange records in descending order of Salary and then limit the count of records to 5. Data in first Record fetched would be highest among thee five records. Hope this helps. Vishal -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED] Behalf Of Priti Chhetri Sent: Tuesday, June 03, 2003 4:23 PM To: [EMAIL PROTECTED] Subject: displaying 5th record Hi All, 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 thanks Priti ========================= 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 =========================================================================== 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
