I want to get unique fields using distinct on 2 columns (ID and \_\_EventType), however, I have been unsuccessful. Here is my attempt that failed but conceptualizes what I'm trying to achieve: 

```
SELECT * FROM (select distinct ID, __EventType from SP_HS_Firm_Calendar_All); 

```

For example here is All my data: 

```
Select ID, __DisplayName, __EventType,EventDate,EndDate from SP_HS_Firm_Calendar_All 

```

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

And here is the data I wish to return using distinct query above: 
[![enter image description here](https://i.stack.imgur.com/mb2Qb.png)](https://i.stack.imgur.com/mb2Qb.png)

Thank you very much for all your help it is much appreciated!