test_tags_count, PostgreSQL

test_tags_count

CREATE TABLE items_tags_sets (
uit_set_id varchar PRIMARY KEY,
item_id varchar,
tag varchar
);

insert into items_tags_sets values('uid1', 'it1', 'tag_test1');
insert into items_tags_sets values('uid2', 'it2', 'tag_test1');
insert into items_tags_sets values('uid3', 'it3', 'tag_test2');
insert into items_tags_sets values('uid4', 'it4', 'tag_test2');
insert into items_tags_sets values('uid5', 'it1', 'tag_test3');
insert into items_tags_sets values('uid6', 'it2', 'tag_test3');
insert into items_tags_sets values('uid7', 'it3', 'tag_test4');
insert into items_tags_sets values('uid8', 'it4', 'tag_test4');
insert into items_tags_sets values('uid9', 'it1', 'tag_test5');
insert into items_tags_sets values('uid10', 'it2', 'tag_test5');
insert into items_tags_sets values('uid11', 'it1', 'tag_test1');
insert into items_tags_sets values('uid12', 'it1', 'tag_test1');
insert into items_tags_sets values('uid13', 'it1', 'tag_test3');
----------------------------------
-- 28062020
select
    items_tags_sets.uit_set_id,
    items_tags_sets.item_id,
    items_tags_sets.tag,
  count(items_tags_sets.tag) as tags_count
  
from items_tags_sets
where 
items_tags_sets.item_id = 'it1'
group by items_tags_sets.uit_set_id, items_tags_sets.tag;


run \| edit \| history \| help	0

Please log in to post a comment.