How many records in output

[Geek_Guest]

Two table 1) dept 2) emp both table having the following values.

deptid dept_name
100 sales
200 finance
300 hr
400 bbbb

empid empname deptid salary
1 a 100 1000
2 b 100 2000
3 c 200 1000
4 d 200 2500
5 e 200 1000
6 f 300 2000

the query is

select deptname
from dept a, emp b
where b.deptid=a.deptid(+)
group by a.deptname
having count(deptname)>=1

my question is the ouput of this query is how many records?

Question asked by visitor indiradharmaraj

[debasisdas]

How many you are getting ?

[RoshanTK]

It should be 6 I believe.

[sridharrganesan]

6 records will be retrieved. In this query outer join is used and there are six records where the dept id in both the tables are same, and the having clause says that only where the count of department is greater or equal to one.

[sqlquiz82]

hi

u will get four records in the output

[svijayaparvathy]

there will be six records in the output.

[Prasanna2883]

The output will be 3 records as we are grouping by Dept Name

[susarlasireesha]

3 Records in output
Deptname
Finance
Hr
Sales