SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table employees( emp_id int(10) not null, first_name varchar(20), last_name varchar (20) not null, dept_id int, salary int (10) not null, primary key (emp_id) ); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (101, 'Mahesh', 'More', 10000, 10), (102, 'Shubh', 'Khare', 20000, 12), (103, 'Rahul', 'More', 30000, 15), (104, 'Ramesh', 'Bore', 40000, 20), (105, 'Shubham', 'Wagh', 50000, 22); delete * from employees where exists ( select emp_id from employees employees_double where employees.last_name = employees_double.last_name employees.emp_id < employees_double.emp_id ); select * from employees;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear