SQL Statement - Check the earliest date as per group of records - If true , return custom text in a custom column

[Luthius]

Guys I have the following problem.
I need to identify if the date of the record is the earliest date of the group.
The idea is NOT return an aggregation table, the idea is return all the records but in a custom column I want to identify if the date of the record is the earliest of the group. If true, then the record of the column will receive a text like "Most Updated record", otherwise, "Discontinued".

Below a simplification of the table where GroupID means foreign key

MyTable

• Id
• GroupID
• RecordDate
• Observations

 

[jackd]

Good luck with your project.

 

[Joe4]

Excellen

Your solution is perfect. Exactly what I was looking for. I just paste the final result of my query based on your solution.

Mr @jackd thank you as well for your support and precious time.

This is the best forum!!!!

Excellent!
Glad to hear that it worked for you!