Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql quesry basic question

sql quesry basic question

From: <soalvajavab1_at_yahoo.com>
Date: 6 Oct 2006 12:50:44 -0700
Message-ID: <1160164244.184071.300370@i42g2000cwa.googlegroups.com>


very basic question but how can I have emp_name in result set as well in the following scenario:

select count(1), aa.dept_no , aa.emp_name from a_target3 aa, a_src2_lookup bb
where aa.dept_no = bb.dept_no
group by aa.dept_no, aa.emp_name

WRONG RESULT:

COUNT(1)	DEPT_NO	EMP_NAME
1	10	Lisa Sharp
1	10	David Jr. Adams
1	11	John Travolta
1	11	Sara F. McDonald
1	12
1	20	Mike Sr Sovolfski


NOW without emp_name:

select count(1), aa.dept_no
from a_target3 aa, a_src2_lookup bb
where aa.dept_no = bb.dept_no
group by aa.dept_no

COUNT(1)	DEPT_NO
2	10
2	11
1	12
1	20

CORRECT RESULT Please advise Received on Fri Oct 06 2006 - 14:50:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US