help with sql statement

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