Oracle Rowid, RowNum and row_number

preview_player
Показать описание
Oracle Rowid, RowNum and row_number...
Explained in detailed...
Рекомендации по теме
Комментарии
Автор

i don't understand why we did self join in the below query
"delete from emp1
where rowid not in
(select max(rowid) from emp1 e1
where emp1.empno = e1.empno );

what i understand from the subquery we got max(highest value) of the rowid. so by using this how we are deleting all the duplicate value

archanazhope
Автор

Why the hell would you add a background music??
This focus intensive content, Please don't add that in future videos.
Thanks in advance.

gauravkumarongoogle
Автор

good info but i don't understand the need of bgm while explaining that's quite distracting

naveentanneru
Автор

are you going to make futher video's don't play back ground music.

hariprasad-dedv