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 }`
You can specify the `--source-map=false` attribute for Angular to load only the stuff that it needs, and will recompile only those parts of your application, that have been modified.

```
ng serve --source-map=false

```

In my case (Angular v.11), `ng serve` takes about 1 minute to serve the app, but the `ng-serve --source-map=false` takes somewhere from 10 to 30 seconds. Moreover, changes are applied much more faster.