Postgresql – Delete duplicate rows using SQL and window function
In the following table create table employee (emp_id integer, emp_name varchar(50), dept_id integer); insert into employee values (1,'bob william',1); insert into employee values (2,'scott tiger',1); insert into employee values (3,'amit gupta',1); insert into employee values (4,'vijay sinha',1); insert into employee…