I have witten a query to delete the duplicate data 

```
DELETE FROM tbl_test t
  WHERE t.ROWID > ANY (SELECT b.ROWID
                          FROM tbl_test b
                         WHERE b.ser_no = t.ser_no
                       );

```

This gives me 199 records which is correct .
Since the duplicate records have status L,F or R . So I have to delete all teh records which are F or R.

For example if I have two records 

```
ID  ser_no   Sta
1    20       L
2    20       F
3    15       R
4    15       L
5    89       L
6    89       F
7    10       R
8    10       R

```

So only one of the duplicate of Status R or F should be Deleted . There is no case in which both dupliate has LL or F,R Status
So I tried 

```
DELETE FROM tbl_test t
      WHERE t.ROWID > ANY (SELECT b.ROWID
                              FROM tbl_test b
                             WHERE b.ser_no = t.ser_no
                             AND b.Sta<>'L'
                           );

```

It did not work. It displays 125 records.

The final result should be 

```
ID  ser_no   Sta
    2    20       F
    3    15       R
    6    89       F
    8    10       R

```