Find highest and lowest salary taker employee

[SA2]

Hi i need to find the name employee name who are taking high salary and low salary. please help in this

Field Names:

MonthlySalary

"First Name"

[ITWhisperer · Accepted solution]

| eventstats min(MonthlySalary) as lowSalary, max(MonthlySalary) as highSalary
| where MonthlySalary=lowSalary OR MonthlySalary=highSalary

[SA2]

its working Thank you

[SA2]

Getting results for every "First Name" field. Evn Before I tired but it's not work

[richgalloway]

What have you tried so far?

... | stats min(MonthlySalary) as lowSalary, max(MonthlySalary) as highSalary by 'First Name'
...