Id Email UserName
1 [email protected] Taiseerjoudeh
2 [Email protected]il.com Hasanahmad
3 [email protected] Moatasemahmad
4 [email protected] Salmatamer
5 [email protected] Ahmadradi
6 [email protected] BillGates
7 [email protected] shareefkhaled
8 [email protected] Aramnaser
9 [email protected] Laylaibrahim
[Email protected] Remaoday
[Email protected] Fikrihusein
[Email protected] Zakarihusein
[Email protected] Laylaibrahim
[Email protected] Tamerwesam
[Email protected] Khaledhasaan
[Email protected] Asaadibrahim
[Email protected] Tareqnassar
[Email protected] Dianalutfi
[Email protected] Tamaramalek
[Email protected] Arwakamal
[Email protected] Salmatamer
[Email protected] Nisreentamer
[Email protected] Salmatamer
Remove the repetitive username
Delete Student2 where Id in
(
Select ID from (
Select Id, Username,row_number () over (partition by UserName ORDER by Id) OrderID from Student2
) T1
where t1.orderid>1
)
Delete field duplicate rows in SQL table