Run Code
|
API
|
Code Wall
|
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
find null in any column of table using PostgreSQL
Final 1
Q4
PosgresSQL Sandbox: Legitimate Resale
Demande complète
a
arjun
sss
75 95
Dashes in numbers