Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help with sql statement
You can retrive the record using 'INLINE VIEW'.
select *
from ( select indate, volume from indexs order by 1 desc)
where rownum <= 2;
"user" <utagi_at_yahoo.com> wrote in message
news:3dfade85$1_2_at_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 - 21:07:53 CST