Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ignore X in group by

474007Apr 5 2006 — edited Nov 5 2010

Hi!

How can i get these results:

ID	VAL
1	A
2	B
3	"a string"
4	C
5	"a string"
6	"a string"
7	"a string"
8	G

from:
ID	VAL
1	A
1	x
1	A
1	x
1	A
1	A
1	A
2	B
2	B
2	B
2	x
2	B
2	x
3	A
3	A
3	K
3	A
3	A
3	A
4	C
4	C
4	x
4	C
4	C
4	x
4	C
5	D
5	B
5	D
5	D
5	D
6	E
6	F
6	E
6	M
6	E
7	L
7	F
7	F
8	G
8	G
8	G
8	G
8	G
8	G
 

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2006
Added on Apr 5 2006
16 comments
10,513 views