??? What is the substitution for the function FIRST in ORACLE????

From: G-Shock <g-shock_at_g-shock.com>
Date: Sat, 26 Feb 2005 19:56:04 +0200
Message-ID: <4220b725$1@news.012.net.il>

Hi There,

there is a table wich includde for examples these fields: FROM_DATE, TO_DATE, DURATION, SOURCE, DESTINATION, ORIGIN_FILE, ORIGIN_ROW, COMMENT... and so on.

What i need is to find the duplicate rows by the fields: FROM_DATE, TO_DATE, DURATION, SOURCE, DESTINATION and
to filter all the duplications.
For the select as above i'll get all the unique rows as mentioned on the group by.
for each row i need the values for the fields: ORIGIN_FILE, ORIGIN_ROW, COMMENT wich exist in the first row.
MS-Access hes FIRST() function but Oracle ): hasn't.

SELECT             FROM_DATE,
                           TO_DATE,
                           DURATION,
                           SOURCE,
                           DESTINATION,
                           First(ORIGIN_FILE),
                           First(ORIGIN_ROW),
                           First(COMMENT)
FROM                Table
GROUP BY        FROM_DATE,
                           TO_DATE,
                           DURATION,
                           SOURCE,
                           DESTINATION
HAVING            Count(*)>1;

Thanks. Received on Sat Feb 26 2005 - 11:56:04 CST