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

Interview Question

Engineering Interview San Mateo, FL

SQL-Query using Self-Joins

Answer

Interview Answer

2 Answers

0

Query to display Employees and their Reporting Manager

Interview Candidate on Jun 2, 2011
0

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

Ani786 on Feb 15, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.