SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table Employee(id int,name varchar(10)); insert into Employee values(1,"ruhi"); insert into Employee values(2,"Suhi"); insert into Employee values(3,"nuhi"); insert into Employee values(5); insert into Employee values(5,"luhi"); insert into Employee values(7,"ouhi"); insert into Employee values(7,"ouhi"); select * from Employee; select id,name,count(*) as cn from Employee group by id,name having count(*)>1; select id,name from Employee where id is null or id='';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear