Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
stackoverflow example for 47702144
create table usr(userID int, fullName varchar(10)); create table savings(ownerID int,dataEnteredByID int); insert into usr values (1,'Michael'), (2,'Peter'), (3,'Jason'), (4,'Christina'), (5,'Anna'); insert into savings values (1,1), (1,2), (1,4), (2,4), (3,3), (4,2), (5,1), (2,2), (4,4), (5,5), (6,1); select ownerID, coalesce(o.fullName,'*UNKNOWN*') as owner, dataEnteredByID, coalesce(u.fullName,'*UNKNOWN*') as clerk from savings s left join usr o on ownerId = o.userID left join usr u on dataEnteredByID = u.userID;
run
|
edit
|
history
|
help
0
book suggestion
project 1
PostgreSQL aggregate JSON recordset keys by row
sql
Update as a function result
proj
Descriptor test
SQL - Social Network Analysis by Patrick Lin
Movie Rating SQL Analysis Conducted by Miranda Zhao
Select the latest id from last week from each different contact without repeating barcodes .....