my sql got a bit rusty and I was wondering if there is a simple solution for my ask. I'm trying to get two unique UUIDs with with MAX ModifiedTime. Below is my code that I tried to simplify as much as possible. My goal is to get unique UUID with its MAX ModifiedDate along with other two associated columns- desired output 2 rows.

```
SELECT [UUID],[Description],IsHLVE,ModifiedTime
FROM tblConstructSecureIntelProjectIncidents
WHERE UUID in ('0b666564-38af-4cc2-9a58-58f9b57244b1','4b6080ea-5c13-4f03-8967-a6beb71e80c4')
ORDER BY UUID,ModifiedTime

```

[![Output for the code above](https://i.stack.imgur.com/C46Hl.png)](https://i.stack.imgur.com/C46Hl.png)

I tried to group by all columns and do max which doesn't work properly since my "description" and "IsHLVE" have different values.

```
select [UUID],[Description],IsHLVE,MAX(ModifiedTime)
FROM tblConstructSecureIntelProjectIncidents
WHERE UUID in ('0b666564-38af-4cc2-9a58-58f9b57244b1','4b6080ea-5c13-4f03-8967-a6beb71e80c4')
GROUP BY [UUID],[Description],IsHLVE
ORDER BY UUID

```

[![Output from my try](https://i.stack.imgur.com/cpzNC.png)](https://i.stack.imgur.com/cpzNC.png)

I believe I need some kind of temporary table first and then join it back?
My desired output should have two unique UUIDs with its max date including all associated columns.