Union : used to stack up (verticaly) two or more data tables, where all duplicate records will be removed Where in; Union all: duplicate records will be there, these records are not removed
Employee salarywali Query: select e.employeeName, e.Salary from employee e Join employee m ON e.employeeId = m.ManagerID where e.salary > m.salary It will return all the records, where employee salary more than manager salary
select e.employeeName, e.Salary from employee e Join employee m ON e.manager_id = m.employee_Id where e.salary > m.salary Join has to be based on manager id from emp table with emp id from manager table!
Union : used to stack up (verticaly) two or more data tables, where all duplicate records will be removed
Where in; Union all: duplicate records will be there, these records are not removed
union - combine the results and union all - combine the results and cotains dublicates.
What an initiative ! Really a great work. Hats off❤
Thank you for your support!
doing great work
Thank you for your support!
🎉🎉🎉
I want to perform sql mock interview
Employee salarywali Query:
select e.employeeName, e.Salary from
employee e
Join employee m
ON e.employeeId = m.ManagerID
where e.salary > m.salary
It will return all the records, where employee salary more than manager salary
select e.employeeName, e.Salary from
employee e
Join employee m
ON e.manager_id = m.employee_Id
where e.salary > m.salary
Join has to be based on manager id from emp table with emp id from manager table!
@zero_analyst ty for clarifications
Waiting for Power BI and python interview also
Will do soon!
Sir i want to give mock interview.. please schedule my interview.i fillup the form