Explain Codes LogoExplain Codes Logo

Sql

How do I perform a GROUP BY on an aliased column in SQL Server?

sql
join
subqueries
ctes

How to Ignore "Duplicate Key" error in T-SQL (SQL Server) #

sql
sql-server
duplicate-key-error
try-catch

Solving a "communications link failure" with JDBC and MySQL

sql
connection-pooling
jdbc-configuration
mysql-optimization

Difference between datetime and timestamp in SQL Server?

sql
data-integrity
concurrency
best-practices

How can I have multiple common table expressions in a single SELECT statement?

sql
ctes
sql-queries
performance

Drop...create vs ALTER

sql
prompt-engineering
best-practices
performance

How to show row numbers in PostgreSQL query?

sql
join
performance
best-practices

How to insert multiple records and get the identity value?

sql
bulk-insertion
identity-values
cursor-free

Sql Server - copy stored procedures from one db to another

sql
sql-server
stored-procedures
database-migration

Select count of rows in another table in a Postgres SELECT statement

sql
join
performance
best-practices

Get Multiple Values in SQL Server Cursor

sql
error-handling
cursor-operations
set-based-operations

Sql SELECT everything after a certain character

sql
substring-extraction
sql-functions
database-ecosystems

Computed / calculated / virtual / derived / generated columns in PostgreSQL

sql
expression-indexes
computed-columns
postgresql

Postgresql create table if not exists

sql
database-management
postgresql
sql-queries

Creating a random number using MySQL

sql
random-number-generation
mysql-functions
database-performance

Column name or number of supplied values does not match table definition

sql
best-practices
data-migration
sql-server-syntax

How to count the number of occurrences of a character in an Oracle varchar value?

sql
prompt-engineering
best-practices
regex

Date in mmm yyyy format in PostgreSQL

sql
date-formatting
postgresql
to_char

Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)

sql
transaction-management
mysql
database-operations

Error when connect database continuously

sql
retry-policies
database-connections
error-handling