Write a query to modify Duplicate ROW from a table !! Tricky MySQL Questions
Вставка
- Опубліковано 15 вер 2024
- Hi All.
Here I have written a query to modify Duplicate ROW from a table-
query-
select id,name,address,mobile,salary,deptid, row_number() over (order by id) as rankno from employee where id=6;
select *,row_number() over (order by id) as rnum from employee;
create table empbackup as select *,row_number() over (order by id) as rnum from employee;
alter table empbackup drop column rnum;
truncate table dd;
insert into dd select * from backupdd;
select * from employee;
alter table dd add primary key (id),
#trickymysqlsquestions
#mysql
#row_number()