Oracle-L: i need ur help

From: Shishir <shishir_at_agnisoft.com>
Date: Thu, 28 Feb 2002 03:43:21 -0800
Message-ID: <F001.0041ACD1.20020228034321@fatcity.com>

Hi List ! I have one problem
SELECT DISTINCT

L.LINE_ID,
L.DSCR ,
L.DSCR_LONG ,

QL.QUOTE_LINE_ID
FROM LINE L,MKT_LINE ML,QUOTE_LINE QL
WHERE
ML.LINE_ID=L.LINE_ID
AND QL.MKT_LINE_ID=ML.MKT_LINE_ID
AND QL.INV_ID =10134 it result is

LINE_ID DSCR DSCR_LONG QUOTE_LINE_ID

 10002 25     Commercial Property       10528
 10002 25    Commercial Property        10529
 10009 52    Workers Comp                 10530

i want to get those line where line id is unique but i can not ditch the Quote_line_id colum . Diffrent quote_line id can refer to same line . So i want to ask is there any way to row wise comparison in SQL itself. in above example i want to ditjch second record as it has same LINE_ID as first one.

Plz help me..

thanx in advance..
Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shishir
INET: shishir_at_agnisoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 28 2002 - 05:43:21 CST