StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

ypercubeᵀᴹ

Rating
1594.08 (2,064th)

Reputation
96,894 (779th)

Page: 1 2 3 4 ... 50

Title	Δ
Need suggestions for writing an optimized SQL query	0.00
Count value and missing FK in one pass	0.00
MySQL Natural Ordering	-1.32
SQL correct check for NOT EQUAL TO NULL	+0.98
Postgresql Select data between selected dates and status	-0.17
Take records between Month and year combination in SQL	-0.14
Why does count(*) not return a single-group?	+2.23
Reuse the SUB Query Columns in SQL	+0.59
MySQL: How do I return only unique entries from one table that don'...	+0.15
Group by Date then by other column	-0.27
Sum of all values except the first	+0.67
Selecting all the similar MAX values derived from COUNT()	-1.75
Alternative to UNION clause in Mysql	+0.82
Error Defining Foreign Key	0.00
Can't find a way to reduce 2 SQL queries to 1 without killing perfo...	0.00
MySql inner join takes more than 10 seconds	-0.15
SQL Sum MTD & YTD	-1.75
MySQL relationship loop	+0.32
UNION ALL does not apply on multiple seperate queries into 6 differ...	0.00
Use clause WHERE on calculated column (including subquery)	0.00
Using JOIN in UPDATE query	+0.13
SQL - Count rows performance tuning	+1.86
DateTime - check for yesterdays data (SQLCe)	-2.22
SELECT COUNT of MAX from GROUP BY with multiple HAVING clauses (I t...	0.00
SQL NOT IN operator not working correctly	-0.38
How to make this query aggregate the time-grouping correct?	0.00
Include NULLs in MAX() OVER PARTITION	0.00
why can't I use WITH (Common Table Expressions) in this query?	+2.02
In SQL, is it possible to use a dummy column in an insert statement?	+2.03
Delete 75% Of a Table Randomly	-2.52
ROW_NUMBER() OVER PARTITION returning duplicate values	0.00
Does it improve performance to index a date column?	+1.58
Mysql results within a specific year on a datetime column	-0.83
greatest-n-per-group where an inner join already exists	0.00
SQL Server 2005 create constraint or indexed view	+0.42
validation using the same table	0.00
Challenging LEFT OUTER JOIN query grouping by MAX	+1.21
move cells left in sql if left contains null and right contains value	-2.02
Deciding FK between tables which have one to one relation	+1.76
Iteration SQL Query?	+0.86
How to optimize MySQL query for a large database	0.00
MySQL - Referencing outer table value from double nested subquery	+1.06
sql query: If a field is a prefix of a key	+0.11
Where is the syntax error in my multiple table join?	0.00
Count distinct ids based on sum of columns	+0.57
SQL Server calculation, how to modify?	-0.13
Posgresql Group By A, but still pull B field	-2.18
Operand should contain 1 column when joining tables with update	-0.26
Order by timestamp works incorrectly	+0.38
MySQL: Get all users not a part of a group	-2.06