Fetching last three records from a table

From: <hassan_ayub_at_yahoo.com>
Date: 2 Oct 2006 09:16:45 -0700
Message-ID: <1159805805.782408.46740_at_k70g2000cwa.googlegroups.com>

[Quoted] 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




[Quoted] [Quoted]      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 Received on Mon Oct 02 2006 - 18:16:45 CEST