---
title: "Find the employees who are managers"  
description: "Find the employees who are managers"  
author: "Sunil Singh"  
published: 2017-11-26  
updated: 2017-11-27  
canonical: https://www.mindstick.com/forum/34368/find-the-employees-who-are-managers  
category: "mssql server"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

# Find the employees who are managers

I want to find that record who is managers for an employees. My [database table](https://www.mindstick.com/forum/159366/how-to-test-regular-expressions-in-sql-without-using-database-table) is like

![Find the employees who are managers](https://www.mindstick.com/mindstickforums/1b5b5b25-fb01-41b8-a69e-ce37348359e6/images/0b2e6d80-cc20-44d0-9664-92023311ef4c.png)\

Can anyone help me to solve this problem..

Thanks in advance

\

## Replies

### Reply by Manish Kumar

Try this

```
SELECT DISTINCT e.emp_id AS 'mng_id', e.emp_name AS 'mng_name'
FROM employees e, employees m WHERE e.emp_id = m.mng_id
```

\


---

Original Source: https://www.mindstick.com/forum/34368/find-the-employees-who-are-managers

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