Explain Codes LogoExplain Codes Logo

Sql

Sql query to select data from 1 hour ago?

sql
timezones
date-functions
sql-queries

Sort NULL values to the end of a table

sql
null-handling
sql-sorting
database-optimization

How do I use properly CASE..WHEN in MySQL

sql
best-practices
sql-queries
conditional-statements

A beginner's guide to SQL database design

sql
database-design
data-integrity
sql-queries

Using SQL count in a case statement

sql
conditional-aggregates
sql-functions
best-practices

How to use a calculated column to calculate another column in the same view

sql
prompt-engineering
best-practices
performance

Select multiple columns from a table, but group by one

sql
join
groupby
subqueries

How to use table variable in a dynamic sql statement?

sql
temp-tables
dynamic-sql
performance

Explanation of self-joins

sql
self-join
data-normalization
performance-optimization

How to restore PostgreSQL dump file into Postgres databases?

sql
database-management
backup-and-restore
postgresql

How to print VARCHAR(MAX) using Print Statement?

sql
dynamic-slicing
varchar-max
print-statement

Describe table structure

sql
information-schema
sql-queries
database-structure

Select from one table matching criteria in another?

sql
prompt-engineering
best-practices
data-modeling

How to store MySQL query results in another Table?

sql
database-design
query-performance
data-integrity

Sql Server 2008: how do I grant privileges to a username?

sql
database-security
sql-server
role-based-access-control

Add row to query result using select

sql
join
data-types
best-practices

T-sql datetime rounded to nearest minute and nearest hours with using functions

sql
datetime
functions
performance

Sql COUNT* GROUP BY bigger than

sql
prompt-engineering
best-practices
join

How to update multiple rows at a time using LINQ to SQL?

sql
bulk-updates
linq-to-sql
performance-optimization

Select all the columns of a table except one column?

sql
dynamic-sql
sql-server
performance
explain.codes / Sql