Re: Fetching last three records from a table

On 2 Oct 2006 09:16:45 -0700, hassan_ayub_at_yahoo.com wrote:

>Hi Folks,
>
> I have the following master-detail tables:
>
> CASES
>
>D_NO VARCHAR2(20)
>D_DATE DATE
>BUDGET_HEAD VARCHAR2(50)
>CONC_PO VARCHAR2(50)
>AMOUNT NUMBER
>REMARKS VARCHAR2(400)
>DIV VARCHAR2(30)
>
>DESCRIPTION VARCHAR2(2000)
>SUB_HEAD VARCHAR2(50)
>
>
> F_DEM_PROG
>
>D_NO VARCHAR2(20)
>REC_FROM VARCHAR2(500)
>SENT_TO VARCHAR2(500)
>TD_DATE DATE
>ACTION VARCHAR2(500)
>REMARKS VARCHAR2(2000)
>SNO NUMBER
>
>
>
>
> 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

This group doesn't do your work for free.

--
Sybrand Bakker, Senior Oracle DBA