Explain Codes LogoExplain Codes Logo

Sql

How to select records from last 24 hours using SQL?

sql
database-optimization
sql-queries
date-and-time

How to execute a .sql script on Heroku?

sql
database-seeding
heroku-cli
rake-task

How can I append a string to an existing field in MySQL?

sql
join
best-practices
dataframe

Update query using Subquery in Sql Server

sql
subqueries
update-queries
sql-performance

How to get next/previous record in MySQL?

sql
performance
best-practices
join

Sql Inner-join with 3 tables?

sql
join
query-optimization
best-practices

Insert data in 3 tables at a time using Postgres

sql
transactional-integrity
concurrent-writes
temporary-tables

How to concatenate columns in a PostgreSQL SELECT?

sql
join
best-practices
performance

Drop all databases from server

sql
database-management
sql-server
database-deletion

How to document a database

sql
database-documentation
version-control
business-rules

Export schema without data

sql
database-structure
export-schema
mysql

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

sql
database-disconnection
sql-server
transactional-integrity

Sql Server 2008: TOP 10 and distinct together

sql
distinct
subqueries
optimizations

How to insert multiple rows in SQLite?

sql
bulk-operations
performance-optimization
sql-queries

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
explain.codes / Sql