Explain Codes LogoExplain Codes Logo

Sql

Using group by on two fields and count in SQL

sql
best-practices
group-by
count

Performance of Cross join with WHERE clause compared to Inner join

sql
performance-tuning
optimization
best-practices

Declare Variable for a Query String

sql
dynamic-sql
parameterized-queries
sql-injection

Sql JPA - Multiple columns as primary key

sql
composite-key
jpa
hibernate

Downsides to "WITH SCHEMABINDING" in SQL Server?

sql
best-practices
schema-binding
sql-server

How to retrieve records for the last 30 minutes in MS SQL?

sql
date-handling
performance-optimization
best-practices

How do you import a large MS SQL .sql file?

sql
import
performance
error-handling

Update one table with data from another

sql
join
best-practices
performance

How to apply bindValue method in LIMIT clause?

sql
prompt-engineering
data-validation
pagination

Efficient latest record query with PostgreSQL

sql
indexing
window-functions
performance-optimization

Why doesn't SQL Server support unsigned datatype?

sql
data-types
performance
best-practices

How to visualize database tables in PostgreSQL using pgAdmin?

sql
database-visualization
pgadmin
postgresql

Mysql: Invalid use of group function

sql
database-design
sql-queries
group-by

How to alter a column and change the default value?

sql
database-structure
sql-commands
data-types

Postgresql unnest() with element number

sql
prompt-engineering
advanced-sql
postgresql

Pass table as parameter into sql server UDF

sql
udfs
sql-server
performance-optimization

Delete all but top n from database table in SQL

sql
performance
best-practices
data-integrity

Delete from two tables in one query

sql
transaction
foreign-key
join

Sql: set existing column as Primary Key in MySQL

sql
database-design
data-types
error-handling

Mysql - how to front pad zip code with "0"?

sql
data-consistency
database-design
sql-best-practices
explain.codes / Sql