User a1ex07

22 votes

Get multiple columns from a select subquery

answered Apr 3, 2012 at 2:00

17 votes

Get the rank of a user in a score table

answered Feb 22, 2012 at 21:00

11 votes

Accepted

Filter Condition Difference - Where Clause vs Join Condition

answered Jan 23, 2018 at 17:03

10 votes

Accepted

Difference between inline view and WITH clause?

answered May 2, 2017 at 14:58

9 votes

Accepted

ORDER BY clause is allowed over column that is not in SELECT list?

answered Feb 18, 2013 at 17:56

8 votes

Splitting SQL query with many joins into smaller ones helps?

answered Jun 1, 2013 at 17:57

8 votes

Accepted

SQL Server Express vs. Oracle Express Edition vs DB2 Express-C

answered Sep 1, 2012 at 14:45

8 votes

Accepted

How can I improve this DB query? it takes too much time

answered Nov 21, 2012 at 16:52

8 votes

Authoritative source that <> and != are identical in performance in SQL Server

answered Nov 18, 2016 at 0:29

8 votes

Accepted

How to call a stored procedure in an Oracle Scheduler job

answered Oct 15, 2015 at 14:44

7 votes

Update one mysql column when another is edited

answered Nov 4, 2015 at 16:17

7 votes

Accepted

SELECT DISTINCT on one column, while returning the other columns?

answered Aug 8, 2012 at 19:08

7 votes

Mysql int vs varchar as primary key (InnoDB Storage Engine?

answered Apr 1, 2012 at 14:49

7 votes

A database in MySQL is a schema in Oracle : I do not understand this statement

answered Mar 4, 2013 at 16:23

7 votes

Accepted

To normalize or not to normalize for few distinct values

answered Feb 24, 2014 at 16:01

6 votes

Pivot rows into multiple columns

answered Dec 10, 2012 at 21:14

6 votes

Can I have one table be an "alias", or "symlink", to another?

answered May 25, 2012 at 23:40

6 votes

How do I preserve the leading zeros when I insert a number into this table?

answered Mar 15, 2012 at 15:48

6 votes

Accepted

What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?

answered Apr 9, 2012 at 16:20

6 votes

File name as primary key?

answered Dec 22, 2011 at 19:24

6 votes

Accepted

Update if not exists statement

answered Dec 10, 2015 at 23:32

6 votes

Accepted

How does the table scan in an UPDATE WHERE predicated on an unindexed column work?

answered May 13, 2015 at 23:21

6 votes

T-SQL: If parameter1 is null, use parameter2

answered Jun 3, 2016 at 22:13

6 votes

Accepted

Trigger to get next prefixed ID: Is there a better way?

answered Jun 27, 2017 at 20:11

5 votes

Accepted

impdp expects wrong file path

answered Jun 11, 2016 at 16:21

5 votes

Accepted

Table check contraint to verify unique on specific value

answered Jul 16, 2018 at 22:21

5 votes

Vacuum on TOAST table

answered Nov 22, 2018 at 16:49

5 votes

Call a stored procedure from a trigger

answered Jan 13, 2012 at 19:01

5 votes

Accepted

Swap Columns on some rows?

answered Dec 26, 2012 at 17:52

5 votes

Accepted

SQL Server OPENQUERY vs Regular Query against AS400

answered Jan 17, 2013 at 16:17

Stack Exchange Network

277 Answers

Get multiple columns from a select subquery

Get the rank of a user in a score table

Filter Condition Difference - Where Clause vs Join Condition

Difference between inline view and WITH clause?

ORDER BY clause is allowed over column that is not in SELECT list?

Splitting SQL query with many joins into smaller ones helps?

SQL Server Express vs. Oracle Express Edition vs DB2 Express-C

How can I improve this DB query? it takes too much time

Authoritative source that <> and != are identical in performance in SQL Server

How to call a stored procedure in an Oracle Scheduler job

Update one mysql column when another is edited

SELECT DISTINCT on one column, while returning the other columns?

Mysql int vs varchar as primary key (InnoDB Storage Engine?

A database in MySQL is a schema in Oracle : I do not understand this statement

To normalize or not to normalize for few distinct values

Pivot rows into multiple columns

Can I have one table be an "alias", or "symlink", to another?

How do I preserve the leading zeros when I insert a number into this table?

What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?

File name as primary key?

Update if not exists statement

How does the table scan in an UPDATE WHERE predicated on an unindexed column work?

T-SQL: If parameter1 is null, use parameter2

Trigger to get next prefixed ID: Is there a better way?

impdp expects wrong file path

Table check contraint to verify unique on specific value

Vacuum on TOAST table

Call a stored procedure from a trigger

Swap Columns on some rows?

SQL Server OPENQUERY vs Regular Query against AS400