Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can we make distinct of one particular column!
Or you could use Reports 2.5.... or you could write your own little packaged
function to help you along ...
something like :-
CREATE OR REPLACE PACKAGE Show_Once
AS
col2_current table.col2%TYPE;
FUNCTION f_col2( v_col2 IN table.col2%TYPE)
RETURN table.col2%TYPE;
PRAGMA RESTRICT_REFERENCES(f_col2, WNDS);
END;
CREATE OR REPLACE PACKAGE BODY Show_Once
AS
FUNCTION f_col2( v_col2 IN table.col2%TYPE)
RETURN table.col2%TYPE
IS
BEGIN
IF col2_current = v_col2 THEN
RETURN NULL;
ELSE
col2_current := v_col2 ; RETURN v_col2 ;
SELECT col1, show_once.f_col2(col2), col3
FROM table
ORDER by col2;
Regards
Lawrence Simela
MAHALINI CONSULTING LIMITED
Ian C. Sellers wrote in message <34B10B35.3CC09E15_at_boco.co.gov>...
>Tushar, I don't believe this will work. Group by requires either that
>you select with sum or group functions or group by every column you
>select.
>
>so this would work:
>
>SELECT COUNT(col1), col2, SUM(col3)
>FROM table
>GROUP BY col2
>
>but the example below will not.
>
>What you could do is to create a view with a select distinct to get only
>col2 and a key, then select from this view in the main statement.
>
>Good luck.
>-Ian
>
>JAYABH wrote:
>
>> If I have understood your question properly, I think what you
>> could do is
>> Select col1,col2,col3
>> from table
>> group by col2
>>
>> i.e you could use group by.
>> Thanks and Bye for now.
>> Tushar
>
>
>
Received on Wed Jan 07 1998 - 00:00:00 CST