Re: Fetching last three records from a table

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 02 Oct 2006 12:17:52 -0700
Message-ID: <1159816670.648209_at_bubbleator.drizzle.com>

hassan_ayub_at_yahoo.com wrote:

> I need to have the last three records from each d_no . What would
> be the query which will return last three records from each d_no
> depending whatever div is selected by the user.
>
> Hassan

Define "last three." Heap tables don't have an order.

Show us your current best attempt and we will give you a hint.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Mon Oct 02 2006 - 21:17:52 CEST

This message: [ Message body ]
Next message: DA Morgan: "Re: Need Oracle 11i / PL SQL spam"
Previous message: Frank van Bortel: "Re: Need Oracle 11i / PL SQL spam"
In reply to hassan_ayub_at_yahoo.com: "Fetching last three records from a table"
Next in thread: hassan_ayub_at_yahoo.com: "Re: Fetching last three records from a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message