StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

Erwin Brandstetter

Rating
1652.91 (517th)

Reputation
567,030 (45th)

Page: 1 2 3 4 5 6 ... 114

Title	Δ
Updating the value of a column	+1.38
How to get data from today's midnight to Yesterday's midnight	-0.99
JOIN table if condition is satisfied, else perform no join	0.00
How to aggregate a table with tree-structure to a single nested JSO...	0.00
Count distinct dates within timestamp by Month SQL	-2.63
Group by columns and fetch rows with maximum length of string in an...	0.00
How to retrieve other columns when performing an aggregate function?	-1.23
Concat setof bytea into single bytea	0.00
How can I make my PostgreSQL select query shorter?	+1.38
How to get first and last row of each island?	+0.29
Is it possible to index on enum?	0.00
Find the nearest overlap between given time series	0.00
Using 0 as Primary Key	0.00
Calculating follower growth over time for each influencer	+1.49
Get the count of distinct userids for last couple of days	+1.17
Update based on same column	-1.87
Unique index by another column for postgresql	-0.45
Why can't I exclude dependent columns from `GROUP BY` when I ag...	0.00
How to check many columns for boundaries set in another table?	0.00
After numerous (error-free) inserts to Aurora (PostgreSQL) RDS serv...	-0.19
Compare date and seconds to timestamp	-2.19
Delete rows depending on values from another table	-0.84
How do I write a function in plpgsql that compares a date with a ti...	+1.36
How to execute a query with a column name passed as parameter to a...	-0.73
SQL unique constraint of a max of two entries per user	+1.72
Dynamically create a table with row values as columns	0.00
SQL SELECT CASE WHEN SUM	-1.31
Simple select query returns no result in postgres database dependin...	0.00
Concatenate columns and adds digits postgresql	0.00
compare only hours in timestamp column postgresql	+0.55
Find the longest concecutive duration of each room_id per weekday	0.00
Select rows based on long list of two columns	0.00
Subqueries using min/max	0.00
Get list of months from one table and counts for each from another	-0.13
Access \set variables in psql for Postgres function bodies	0.00
How to ensure entries with non-overlapping time ranges?	0.00
PostgreSql : Json Array to Rows using Lateral Join	-2.03
Postgresql query returns string values between quotation marks &quo...	0.00
Complex nested aggregations to get order totals	0.00
Remove numeric item from JsonB array	+1.93
Get the latest child messages and also parent messages that are chi...	+1.28
User table for many tables to login	-0.88
Is there a way to set multiple column values on a single spatial qu...	-2.14
Insert database into new database with extra column	0.00
Return five rows of random DNA instead of just one	-0.21
Postgresql trying to use execute format in a function but getting c...	0.00
Count the number of scales	0.00
SELECT value depending on underlying table name	+1.56
How to force evaluation of subquery before joining / pushing down t...	0.00
Select rows from database using varying multiple WHERE conditions	0.00