-
duplicated records...I want just one row...
Hi all...
I got this small problem...
which it's taking time..
I have this tables:
ESC_SUPP
(PK = SUPP_CODE)
SUPP_CODE GSL_CODE
S1 110
S2 110
S4 111
S5 111
ESC_SUP_PART
(PK = SUPP_CODE, PART)
SUPP_CODE PART
S1 A1
S2 A1
S4 A1
S5 A1
Then, when I submit this query:
select b.part, a.gsl_code , count(1)
from esc_supp a,
esc_sup_part b
where a.supp_code = b.supp_code
and b.part = 'A1'
group by a.gsl_code, b.part
result:
PART GSL_CODE COUNT(1)
A1 110 2
A1 111 2
Goal: I need to get Only One row, any
of the above, since I will put the query inside a PL/SQL code.
How can do this without using
subqueries?
I hope you can help me...
Thanks in adcance!
JC.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|