Explain Codes LogoExplain Codes Logo

Sql

Cleanest way to build an SQL string in Java

sql
prepared-statements
sql-injection
spring-jdbc

Select SQL Server database size

sql
database-management
sql-server
database-performance

Sql SELECT WHERE field contains words

sql
full-text-search
database-performance
sql-server

How to skip the first n rows in sql query

sql
sql-performance
sql-tuning
sql-execution-plans

What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?

sql
best-practices
performance
sql-optimizers

Determine a table's primary key using TSQL

sql
database-management
data-integrity
sql-server

How to print SQL statement in a CodeIgniter model

sql
database-debugging
query-logging
profiler-class

Oracle SQL escape character (for an '&')

sql
sql-escape
oracle-sql
substitution-variables

How to run .sql file in Oracle SQL developer tool to import database?

sql
database-import
sql-developer
oracle

How to randomly select rows in SQL?

sql
randomness
performance-tuning
database-management

Selecting by month in PostgreSQL

sql
date-functions
postgresql
sql-queries

How to perform a left join in SQLAlchemy?

sql
join
orm
performance

Django in / not in query

sql
subqueries
django-orm
database-performance

Sql NOT IN not working

sql
database-integrity
query-optimization
sql-performance

Sql Statement using Where clause with multiple values

sql
join
group-by
stored-procedures

How big is too big for a PostgreSQL table?

sql
database-maintenance
data-partitioning
indexing

Use tnsnames.ora in Oracle SQL Developer

sql
tnsnames.ora
oracle-sql-developer
environment-variables

Grouping timestamps by day, not by time

sql
date-functions
performance-optimization
aggregation

Postgresql: how to convert from Unix epoch to date?

sql
timestamp
date-conversion
postgresql

Postgresql calculate difference between rows

sql
prompt-engineering
best-practices
dataframe