OraFAQ Forum: SQL & PL/SQL » How to select a group distinct row from one table with fewer keys

Home » SQL & PL/SQL » SQL & PL/SQL » How to select a group distinct row from one table with fewer keys

Thu, 07 March 2002 22:30

wangshitao
Messages: 3
Registered: March 2002

Junior Member

one table T with fields k1,k2,k3,c
the key is k1,k2,k3

how to select k1,k2,c with c = 'a' and
distinct (k1, k2)
in one statement

Thu, 07 March 2002 22:42

a
Messages: 22
Registered: March 2002

Junior Member

you have given "key is k1,k2,k3"
what does it mean.
if it is unique key or composite primary key it will be distinct.

put it more clearly

Previous Topic:	Database Triggers
Next Topic:	Re: How to select a group distinct row from one table with fewer keys

Goto Forum:

]

Current Time: Fri Apr 19 13:43:49 CDT 2024