Guidewire Interview Question: SQL-Query using Self-Joins... | Glassdoor

Interview Question

Engineering Interview San Mateo, FL

SQL-Query using Self-Joins


Interview Answer

2 Answers


Query to display Employees and their Reporting Manager

Interview Candidate on Jun 2, 2011

select boss.emp_name(Big Boss), slave.emp_name(Small SLAVE) from employee boss, employee slave where boss.emp_id=slave.mgr

Ani786 on Feb 15, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.