hi Priti, use rowid to get the top 5 records see article http://technet.oracle.com/sample_code/tech/java/sqlj_jdbc/files/basic/RowidS ample/Readme.html
i guess it will help u in this Regards Veeren -----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
