[![enter image description here](https://i.stack.imgur.com/jVYbs.png)](https://i.stack.imgur.com/jVYbs.png)

[![enter image description here](https://i.stack.imgur.com/S7GKb.png)](https://i.stack.imgur.com/S7GKb.png)

When I do

```
select * , empname as managerName

```

I want all data then just `managerName`