Delete duplicates with different timestamps

Asked Feb 06 '23 at 14:35

Active Feb 06 '23 at 14:42

Viewed 32 times

Hey in SSMS I have this query:

SELECT MessageID
,MessageName
,DateTimeStamp
FROM faa_source_cleansed.message_meta_data

and have data in it like this:

I want to delete the rows where timestamp is greater than the smallest one.

So the result should be like this:

edited Feb 06 '23 at 14:42

asked Feb 06 '23 at 14:35

Sagar Negi US

You say you "want to delete the rows"; do you *actually* mean `DELETE`? – Thom A Feb 06 '23 at 14:38
@Larnu Yes I want to ```DELETE``` – Sagar Negi US Feb 06 '23 at 14:43
Does the MessageName matter? – jarlh Feb 06 '23 at 14:55
Sample data like A, B and C is much easier to read than MS_2srpuI0UBZC0yMe, MS_2stpuI0UBZC0yMe and MS_2srpu10UBZC0yMe. Make it easy to assist you! – jarlh Feb 06 '23 at 14:56

0 Answers0