SQL Query to display records that dont match in consecutive rows

[Ann VK]

I have a table with records like:
ID End Price
A 20060625 5.70250000000000000000
A 20060725 5.76500000000000000000
A 20060825 5.70438000000000000000
A 20060925 5.71000000000000000000
A 20061025 5.70000000000000000000
A 20061125 5.70000000000000000000
A 20061225 5.73000000000000000000
A 20070125 5.70000000000000000000

I want to get a query which would give the result as:
ID End Price
A 20060625 5.70250000000000000000
A 20060725 5.76500000000000000000
A 20060825 5.70438000000000000000
A 20060925 5.71000000000000000000
A 20061025 5.70000000000000000000
A 20061225 5.73000000000000000000
A 20070125 5.70000000000000000000

The reason is that the 5th and 6th record had the same price. Then I dont want to display that. So in other words i want to be able to compare the prices between each consecutive rows and return only the rows that dont match. Is it possible to do it in a single query?

[Rabbit]

You could use the row_number function to number the rows and then join it to itself to get the previous row to see if they match.

[Ann VK]

@Rabbit
Thanks you so much for your suggestion. I tried this way and it worked!!

Just in case someone wants to see the query, i created a view for this with query:

with cte_rownum (Ranks,ID,End_Date,Price) as
(select rank() over (order by ID,End_Date) as rank,
ID,End_Date,Price from PriceTable)

select a.* from cte_rownum a inner join cte_rownum b on a.ranks = 1 where a.Price <> b.Price
union
select b.* from cte_rownum a inner join cte_rownum b on a.ranks = b.ranks-1 where a.Price <> b.Price

[Rabbit]

Not a problem Ann, good luck.