Explain Codes LogoExplain Codes Logo

Sql

Difference between two dates in MySQL

sql
date-manipulation
timestamp
performance-optimization

Difference between EXISTS and IN in SQL?

sql
join
subqueries
optimization

How to use GROUP BY to concatenate strings in SQL Server?

sql
string-aggregation
sql-server
concatenation

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

sql
data-type-mismatches
conversion-tools
database-migration

Get a list of dates between two dates

sql
temp-tables
date-range
performance-optimization

Sql Server Convert Varchar to Datetime

sql
date-format
datetime-conversion
sql-server

Select rows with same id but different value in another column

sql
join
distinct
performance

How to get the difference between two dates rounded to hours

sql
date-functions
time-difference
sql-queries

Sql server stored procedure return a table

sql
stored-procedures
sql-server
database-design

Convert negative data into positive data in SQL Server

sql
best-practices
performance
sql-server

Creating a stored procedure if it does not already exist

sql
stored-procedures
sql-server
database-integrity

Move SQL data from one table to another

sql
data-transfers
sql-server
mysql

Delete duplicate rows from small table

sql
delete-duplicates
postgresql
data-management

Creating table names that are reserved words/keywords in MS SQL Server

sql
best-practices
database-design
sql-server

Remove trailing zeros from decimal in SQL Server

sql
data-integrity
decimal-precision
sql-conversions

Sql to find the number of distinct values in a column

sql
distinct-count
sql-queries
database-performance

Generate random int value from 3 to 6

sql
random-number-generation
sql-server
database-performance

How to round an average to 2 decimal places in PostgreSQL?

sql
prompt-engineering
best-practices
dataframe

Sql Server Case Statement when IS NULL

sql
case-statement
sql-server
data-type-consistency

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

sql
collation
mysql-error
database-migration