Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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.
book suggestion
Game Play Analysis (511,512,534,550)
Movie Rating SQL Analysis Conducted by Miranda Zhao
array comparison
Descriptor test
postgresql select test
test 16721723
Correlated subquery in SELECT clause, and rewritten for Netezza
first
Descriptor test
Please log in to post a comment.