I'd like to retrieve an integer value in a SQL Select but only when the data changes, e.g.:
Table data:
50 50 50 52 50 30 30 35 30 30 60 65 60 60
Now I'd like to get this data:
50 52 50 30 35 30 60 65 60
Executing a distinct query, this would not work for me because it would retrieve:
50 52 30 35 60 65
Any ideas?
I'm working with Entity Framework and C#, so suggestions using them would also be appreciated!
Thanks.