Re: Last 100 rows

From: Carsten Jacobs <carsten.jacobs_at_tool42.com>
Date: 2000/04/28
Message-ID: <3909DC47.ED986DD1@tool42.com>#1/1

How about:
select * from

	(select *
	from huge_tab
	order by order_col DESC)

where rownum < 101;

Carsten

sang schrieb:
>
> Hi ,all
>
> I want to get my last 100 rows data from my huge table ordered by date.
> and i want to get the last row too.
> I know i can Select * from hugetable and move to the last, but it will take
> much
> time for it.
>
> Has anyone a quick way?
>
> Thanks in advance
 

-- 

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is 
prohibited. If you received this in error, please contact the sender and
delete the material from any computer.

Received on Fri Apr 28 2000 - 00:00:00 CDT