Question: I have a table like below

```
Order_Id (PK), Customer_ID, Order_Amount
  A01             AA01         100
  A01             AA01         100 (duplicate)
  A02             AA01         200
  A03             AA02         300

```

I want to remove the duplicate and retain the remaining one

I'm able to select the duplicate using below

```
select *
from 
(
select order_id, customer_id, order_amount, row_number () over (partition by order_id order by order_Id) as rnk
from mytable
) where rnk > 1

```

But what's the next step to delete this record from mytable? Do I need to create a interim table?

Thanks!

Answer: 
Most of the time ng serve takes too long because of `@angular-devkit` downgrading the version might work. Since you are using angular 9 you can enable ivy compilation in tsconfig file by adding 
`"angularCompilerOptions": { "enableIvy": true }`
Use the --verbose option to see what's going wrong behind the scenes:

```
ng serve --verbose

```