Not getting desired rows
I want to find the manager in each department who has from_date = 1995.-.-. I am getting 20 rows. but when I want to add salary to this table , I am getting 73 rows.
3 answers ( 0 marked as helpful)
Hi Abrar!
Thanks for reaching out.
This is because different managers have earned different salaries during the different periods of time. So, when you add records from the salaries table, you obtain a different result set.
Hope this helps.
Best,
Tsvetelin
Hi, when I used ' group by' 'emp_no', I got 20 rows as usual. How is that?
Hi Abrar!
Thanks for reaching out.
Could you please share with us the query you are asking for? Thank you.
Looking forward to your answer.
Best,
Tsvetelin