---
title: "Write a sample query for self join?"  
description: "Write a sample query for self join?"  
author: "Anonymous User"  
published: 2014-10-13  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/2222/write-a-sample-query-for-self-join  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 1 minute  

---

# Write a sample query for self join?

Select e1.ename, e2.empid from emp e1, emp e2 where e1.empid=e2.mgrid

## Answers

### Answer by Anonymous User

Select e1.ename, e2.empid from emp e1, emp e2 where e1.empid=e2.mgrid


---

Original Source: https://www.mindstick.com/interview/2222/write-a-sample-query-for-self-join

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.