Home » SQL & PL/SQL » SQL & PL/SQL » select problem HelP!!!
select problem HelP!!! [message #19272] Thu, 07 March 2002 22:11 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

how to select k1,k2,c with c = 'a' and distinct k1 and k2 in one statement
Re: select problem HelP!!! [message #19285 is a reply to message #19272] Fri, 08 March 2002 04:23 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
here is one way:

select k1,k2,c from table1 where c='a'
group by k1,k2,c
Previous Topic: Re: How to select a group distinct row from one table with fewer keys
Next Topic: Explain and where xxxx Like ......
Goto Forum:
  


Current Time: Thu Mar 28 06:10:06 CDT 2024