Sql

How to resolve ambiguous column names when retrieving results?

data-discrepancies

How to detect query which holds the lock in Postgres?

lock-investigation

postgres-queries

database-performance

Postgres - Function to return the intersection of 2 ARRAYs?

array-operations

What is the difference between ";" and "GO" in T-SQL?

Oracle insert from select into table with more columns

data-type-compatibilities

Alter a MySQL column to be AUTO_INCREMENT

database-management

data-structures

Postgresql: using a calculated column in the same query

Create a one to many relationship using SQL Server

database-design

Mysql insert random datetime in a given datetime range

T-sql: Using a CASE in an UPDATE statement to update certain columns depending on a condition

update-statements

Mysql concatenation operator

concat-function

Sql: IF clause within WHERE clause

conditional-statements

sql-performance

How do I use an INSERT statement's OUTPUT clause to get the identity value?

insert-statement

Ora-12560: TNS:protocol adapter error

tns-protocol-error

oracle-services

Creating new database from a backup of another Database on the same server?

Mysql procedure vs function, which would I use when?

transaction-management

database-security

performance-optimization

Difference of two date time in SQL Server

List rows after specific date

date-comparisons

sql-performance

In Clause with NULL or IS NULL

What is the difference between IFNULL and COALESCE in MySQL?

explain.codes / Sql