Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL to retrieve all distinct records
How are you throwing away SYS SYS2 R3 ?=20
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org=20
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alison Barak
> Sent: 15 April 2004 14:38
> To: oracle-l_at_freelists.org
> Subject: SQL to retrieve all distinct records
>=20 >=20
>=20
> SQL> select * from testing;
> A B C
> ---------- ---------- ----------
> APPS APPS R1
> SYS SYS2 R2
> SYS SYS2 R3
> DOC DOC2 R4
> DC DC2 R5
> DOC DOC R6
>=20
> The result should be
> A B C
> ---------- ---------- ----------
> APPS APPS R1
> SYS SYS2 R2
> DOC DOC2 R4
> DC DC2 R5
> DOC DOC R6
>=20 >=20
>=20
>=20
>=20> MSN Toolbar provides one-click access to Hotmail from any Web=20
> _________________________________________________________________
>=20> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 15 2004 - 09:27:50 CDT