SQL Select when data changes

Viewed 161

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.

4 Answers
Related