SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE DATPUBLICDOC( DataID int, DataConfidLevel varchar(80) ); INSERT INTO DATPUBLICDOC VALUES( 1245,'Коммерческая тайна'); INSERT INTO DATPUBLICDOC VALUES( 1145,' Не коммерческая тайна'); INSERT INTO DATPUBLICDOC VALUES( 1246,'Коммерческая тайна'); CREATE TABLE DATPUBLICUSER( UserID int, UserName varchar(80)); INSERT INTO DATPUBLICUSER VALUES( 12,'Иванов А.A'); INSERT INTO DATPUBLICUSER VALUES( 13,'Петров А.A'); INSERT INTO DATPUBLICUSER VALUES( 14,'Сидоров А.A'); CREATE TABLE DATPUBLICCOMMON( UserID int, DataID int); INSERT INTO DATPUBLICCOMMON VALUES( 12,1245); INSERT INTO DATPUBLICCOMMON VALUES( 13,1145); INSERT INTO DATPUBLICCOMMON VALUES( 12,1245); INSERT INTO DATPUBLICCOMMON VALUES( 13,1145); INSERT INTO DATPUBLICCOMMON VALUES( 14); INSERT INTO DATPUBLICCOMMON VALUES( 12); INSERT INTO DATPUBLICCOMMON VALUES( 12,1246); select user_name , sum(case when datalevel = 'CommTaina' then 1 else 0 end) from pub_user, pub_common left outer join doc on doc.dataid = pub_common.dataid and doc.datalevel = 'CommTaina' where pub_user.userid = pub_common.userid group by user_name
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear