Explain Codes LogoExplain Codes Logo

Sql

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?

sql
subqueries
join
performance

Naming convention for unique constraint

sql
best-practices
database-design
constraint-naming

How to increment an integer column's value by 1 in SQL

sql
update
increment
sql-queries

How to use index in select statement?

sql
indexing
database-performance
query-optimization

Duplicating a TABLE using Microsoft SQL Server Management

sql
prompt-engineering
best-practices
data-integrity

Cannot access field in Big Query with type ARRAY>

sql
prompt-engineering
array-manipulation
bigquery

Group by minimum value in one field while selecting distinct rows

sql
prompt-engineering
best-practices
performance

How do I return rows with a specific value first?

sql
advanced-sorting
performance-optimization
sql-indexes

Is it possible for SQL Output clause to return a column not being inserted?

sql
advanced-data-capturing
merge-statement
output-clause

Creating an index on a table variable

sql
indexing-strategies
sql-server
performance-optimization

How can I group time by hour or by 10 minutes?

sql
prompt-engineering
interview-preparation
best-practices

How do I batch sql statements with package database/sql

sql
batch-insert
database-performance
sql-optimization

Just get column names from a Hive table

sql
hive-command
column-names
table-metadata

Passing an array of parameters to a stored procedure

sql
tvp
xml-serialization
dynamic-sql

How to return default value from an SQL query

sql
sql-performance
best-practices
query-optimization

Oracle 'Partition By' and 'Row_Number' keyword

sql
prompt-engineering
join
deduplication

How to select id with max date group by category in PostgreSQL?

sql
prompt-engineering
best-practices
performance

What is the equivalent of 'describe table' in SQL Server?

sql
database-documentation
metadata-visibility
sql-scripts

Command for adding a default constraint

sql
database-design
data-consistency
sql-best-practices

Mysql select rows where left join is null

sql
join
left-join
subqueries
explain.codes / Sql