Stack Exchange

ypercubeᵀᴹ

Athens, Greece and London, UK

http://in.another.dimension

Interests: math, programming and games, not necessarily in that order.

Favourite numbers: Surreals

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
287
MySQL COUNT DISTINCT
stackoverflow.com

201
Does the join order matter in SQL?
stackoverflow.com

194
Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation
stackoverflow.com

191
MySQL IF NOT NULL, then display 1, else display 0
stackoverflow.com

146
What are the mathematical/computational principles behind this game?
stackoverflow.com

139
Good explanation of cascade (ON DELETE/UPDATE) behavior
dba.stackexchange.com

107
MySQL date formats - difficulty Inserting a date
stackoverflow.com

107
must appear in the GROUP BY clause or be used in an aggregate function
stackoverflow.com

102
How to use SQL Select statement with IF EXISTS sub query?
stackoverflow.com

101
SQL: set existing column as Primary Key in MySQL
stackoverflow.com

81
Using IS NULL or IS NOT NULL on join conditions - Theory question
stackoverflow.com

77
mysql “Where not in” using two columns
stackoverflow.com

75
row-level trigger vs statement-level trigger
stackoverflow.com

74
Graph auto-layout algorithm
stackoverflow.com

71
What is the maximum size of int(10) in Mysql
stackoverflow.com

70
Format date in MySQL SELECT as ISO 8601
stackoverflow.com

67
Sorting by date & time in descending order?
stackoverflow.com

64
How do I insert a row which contains a foreign key?
dba.stackexchange.com

61
Why does this query work?
dba.stackexchange.com

57
MySQL sort by some list
stackoverflow.com

52
How to correctly do upsert in postgres 9.5
stackoverflow.com

51
How to select rows that have current day's timestamp?
stackoverflow.com

51
How to limit maximum number of rows in a table to just 1
dba.stackexchange.com

50
CHECK constraint in MySQL is not working
stackoverflow.com

49
How to combine date and time to datetime2 in SQL Server?
dba.stackexchange.com

48
MySQL: #1075 - Incorrect table definition; autoincrement vs another key?
stackoverflow.com

46
How to select specific rows if a column exists or all rows if a column doesn't
dba.stackexchange.com

45
EXISTS (SELECT 1 …) vs EXISTS (SELECT * …) One or the other?
dba.stackexchange.com

43
selecting where two columns are in a set
dba.stackexchange.com

43
In SQL, is it OK for two tables to refer to each other?
stackoverflow.com

1 2 3 4 5 … 10