Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Hod do I select the last 100 records of a Table.
Assuming that the temp table and your other table have the same fields, the
syntax is
insert into temp table
select * from table_name......
If not, specify the fiels you want to insert.
Mark
Glen Gray wrote in message <376F6B47.5B097F0_at_bsolved.com>...
>I know it sounds like a simple request but I can't get it to work.
>
>If I do :
>
>select * from table_name where rownum<=100 order by recordid desc
>
>I get the first 100 records back in reverse order. I haven't been able
>to do a select into #tmp_table either. I need to get this working fairly
>quickly so any help would be greatly appreciated.
>
>It's Oracle Server 8.0.3 running on NT Server.
>
>Thanks in advance.
>
>Glen Gray
>
Received on Tue Jun 22 1999 - 05:58:15 CDT