Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help with sql statement

help with sql statement

From: user <utagi_at_yahoo.com>
Date: Sat, 14 Dec 2002 15:52:53 +0800
Message-ID: <3dfade85$1_2@news.tm.net.my>


does anybody know what is the sql statement to retrieve the last date in a table ?
i need the statement to retrieve the volume of the last and 2nd last date and display them into a text box in my vb ....

SQL> select * from indexs;

INDATE INDEXS VOLUME

--------- ---------- ----------
29-JUN-00     830.25        237
30-JUN-00     833.37        160
03-JUL-00     793.93        104
04-JUL-00     807.87         89

thanks Received on Sat Dec 14 2002 - 01:52:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US