In an interview the below questions asked and couldn't provide an appropriate answer.
Question 1: if i have a table with employee id and manager i want to display it in the below format with employee name and manager.( the employee id 1 have manager null. You need to use self join only)
Question 2: if i have same result got for inner join ,right outer join and left outer join what type of content that table have?
Can anyone help me to find out answer for this?
Aucun commentaire:
Enregistrer un commentaire