How to delete duplicate records in sql-19 #kannababu

in this video i explained about from clause and Row_number() in sql

[KannababuBanna]

what ever the modification that we do for cte these modifications will automatically affect to original table

[trishuldhakulkar]

sir, what is query to get the records from the tabel based on the id that generate automatically by database when we enter some record... because these id table not having any colume name

[KannababuBanna]

hi cte is temporary memory when we try to execute inner select query the result of inner query will store in cte .cte always work s with with clause listen part1 234 then u will understand about partition by, cte, row-numer()

[arshnareshsufi]

As you said I tried to delete some duplicate records from emp table but I am getting ORA-00906: missing left parenthesis

with emp(first_name, rowno)
as(
SELECT first_name, rowno, row_number()over(partition by(first_name)order by(rowno)asc from emp)delete from emp where rowno >1);



And why we are using "with" why can't we use "select"

[arshnareshsufi]

Hi Sir,
Are we need to create the one more column(rowno) for deleting the duplicate records?

Please kindly revert back ASAP.

[madanapalikishore]

sir can u upload StoredProcedure and Stored Functions Videos

[vbaksh]

sir can I get it store procedure video