Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
LeetCode 178
--PostgreSQL 9.6 --'\\' is a delimiter Create table Scores ("id" int, "score" DECIMAL(3,2)); insert into Scores (id, score) values (1, 3.5), (2, 3.65), (3, 4.0), (4, 3.85), (5, 4.0), (6, 3.65);
run
|
edit
|
history
|
help
0
Assignment 1(SET A)
to_char(now(), 'YYYYddd')
Assignment 1(SET A)
cte
Return IDs where there are exactly 3 occurrences1
SQL social network practice by Han Wang 20200720
Return IDs where there are exactly 3 occurrences
Stack
Shortest "path" between two employees across companies
Assignment 1(SET A)