Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sql quesry basic question
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
![]() |
![]() |