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 subscriptions

Can spatial index help a "range - order by - limit" query

postgresql database-design index performance query-performance asked May 22, 2012 at 21:19

dba.stackexchange.com

25 votes

Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?

database-design foreign-key referential-integrity asked May 14, 2012 at 23:02

dba.stackexchange.com

14 votes

C weird array syntax in multi-dimensional arrays

c arrays multidimensional-array pointer-arithmetic asked Nov 13, 2011 at 2:49

stackoverflow.com

11 votes

Optimization problem: compound clustered keys, flag conditions and index-merge

mysql mysql-5.5 optimization asked Aug 3, 2012 at 11:02

dba.stackexchange.com

10 votes

Why chat profile in some rooms does not have a parent SE profile?

bug status-completed chat network-profile asked Jun 4, 2012 at 7:56

meta.stackexchange.com

8 votes

Performance of query with a range condition and order by

database-design index performance sqlite query-performance asked May 22, 2012 at 19:36

dba.stackexchange.com

7 votes

Replication error

mysql replication mysql-5.5 asked Jul 26, 2013 at 23:22

dba.stackexchange.com

7 votes

GROUP BY query optimization

mysql group-by query-optimization myisam asked May 20, 2011 at 12:26

stackoverflow.com

5 votes

Do I deserve downvotes for answering such a simple question?

discussion down-votes vote-to-close asked Feb 25, 2012 at 10:42

meta.stackexchange.com

Top Answers

315

MySQL COUNT DISTINCT

stackoverflow.com

313

Does the join order matter in SQL?

stackoverflow.com

301

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

stackoverflow.com

261

MySQL IF NOT NULL, then display 1, else display 0

stackoverflow.com

224

Good explanation of cascade (ON DELETE/UPDATE) behavior

dba.stackexchange.com

179

must appear in the GROUP BY clause or be used in an aggregate function

stackoverflow.com

157

What are the mathematical/computational principles behind this game?

stackoverflow.com

156

How to use SQL Select statement with IF EXISTS sub query?

stackoverflow.com

144

MySQL date formats - difficulty Inserting a date

stackoverflow.com

123

SQL: set existing column as Primary Key in MySQL

stackoverflow.com

116

Using IS NULL or IS NOT NULL on join conditions - Theory question

stackoverflow.com

113

Format date in MySQL SELECT as ISO 8601

stackoverflow.com

110

How do I insert a row which contains a foreign key?

dba.stackexchange.com

104

What is the maximum size of int(10) in Mysql

stackoverflow.com

mysql "Where not in" using two columns

stackoverflow.com

Sorting by date & time in descending order?

stackoverflow.com

Graph auto-layout algorithm

stackoverflow.com

row-level trigger vs statement-level trigger

stackoverflow.com

selecting where two columns are in a set

dba.stackexchange.com

How to correctly do upsert in postgres 9.5

stackoverflow.com

MySQL: #1075 - Incorrect table definition; autoincrement vs another key?

stackoverflow.com

How to select rows that have current day's timestamp?

stackoverflow.com

MySQL sort by some list

stackoverflow.com

In SQL, is it OK for two tables to refer to each other?

stackoverflow.com

Postgres won't accept table alias before column name

stackoverflow.com

Why does this query work?

dba.stackexchange.com

Using 'case expression column' in where clause

stackoverflow.com

EXISTS (SELECT 1 ...) vs EXISTS (SELECT * ...) One or the other?

dba.stackexchange.com

How to limit maximum number of rows in a table to just 1

dba.stackexchange.com

How to combine date and time to datetime2 in SQL Server?

dba.stackexchange.com