Selecting Changed Rows Only

Hi experts,

I have been trying to limit the table rows in the following situation,
any suggestions will be appreciated.

we have table called tempTb has columns id, c_id, c_name, rating, date
columns.
id is an identity column.
date is a datetime column, the rest are varchar datatype.
Here is the table structure with sample data,

idc_idc_nameratingdate
1aoamer onli11/1/2002
2aoamer onli13/1/2002
3aoamer onli16/1/2002
4aoamer onli39/1/2002
5aoamer onli312/1/2002
6aoamer onli33/1/2003
7aoamer onli36/1/2003
8aoamer onli39/1/2003
9aoamer onli212/1/2003
10aoamer onli16/1/2004
11aoamer onli112/1/2004
12xyxabs yasd11/1/2002
13xyxabs yasd23/1/2002
14xyxabs yasd26/1/2002
15xyxabs yasd29/1/2002
16xyxabs yasd112/1/2002
17xyxabs yasd13/1/2003
18xyxabs yasd36/1/2003
19xyxabs yasd39/1/2003
20xyxabs yasd212/1/2003
21xyxabs yasd16/1/2004
22xyxabs yasd112/1/2004
[color=blue]
>From this table I need to select the rows with rating changes only,[/color]
i.e if two or three consecutive rows have same rating only the first
row should be selected.

the selection should look like...
idc_idc_nameratingdate
1aoamer onli11/1/2002
4aoamer onli39/1/2002
9aoamer onli212/1/2003
10aoamer onli16/1/2004
12xyxabs yasd11/1/2002
13xyxabs yasd23/1/2002
16xyxabs yasd112/1/2002
18xyxabs yasd36/1/2003
20xyxabs yasd212/1/2003
21xyxabs yasd16/1/2004

I was trying to do this by self-joining the table like....

select t1.* from tempTb t1, tempTb t2
where t1.id!=t2.id,
t1.c_id=t2.c_id,
t1.c_name=t2.c_name,
t1.rating!=t2.rating.
But this is generating cartesian products,
I have tried some other combinations after where clause with date colmn
wtc,
but none seems to give the required result.

so if anybody can guide me in the right direction I would appreciate
it.

Thanks alot,
Remote