Consider two relational tables:
Employee:
|
Emp_id |
Emp_name |
Emp_sex |
Emp_designation |
|
1 |
Mahesh |
Male |
SD |
|
2 |
Rahul |
Male |
CD |
|
4 |
Ravi |
Male |
TM |
|
5 |
Swati |
Female |
TL |
Company :
|
Emp_id |
Company_name |
Company_address |
|
1 |
Nokia |
Gwalior |
|
1 |
Samsung |
Chandigarh |
|
2 |
HP |
Panchkula |
|
3 |
Apple |
Morena |
Where Emp_id in company relation references to Emp_id in Employee relation.
How many numbers of rows are possible in output of the below query?
(SELECT *FROM Employee E, Company C where E.Emp_id < > C.Emp_id and E.Emp_id % C.Emp_id) intersect (SELECT *FROM Employee E Left outer join Company C on E.Emp_id % C.Emp_id OR E.Emp_name = ‘Mahesh’ OR C. Company_name = ‘HP’ or ‘Apple’)
Enter numerical value using the virtual keypad. Round off where necessary.