Home » SQL & PL/SQL » SQL & PL/SQL » How to select a group distinct row from one table with fewer keys
How to select a group distinct row from one table with fewer keys [message #19274] Thu, 07 March 2002 22:30 Go to next message
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
Re: How to select a group distinct row from one table with fewer keys [message #19276 is a reply to message #19274] Thu, 07 March 2002 22:42 Go to previous message
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: Tue Oct 19 19:00:01 CDT 2021