Explain Codes LogoExplain Codes Logo

Sql

Postgres manually alter sequence

sql
sequences
setval
database-performance

New Line Issue when copying data from SQL Server 2012 to Excel

sql
new-line
excel
ssms

How do I query between two dates using MySQL?

sql
date-queries
date-format
string-to-date

Can I concatenate multiple MySQL rows into one field?

sql
group-concat
distinct
data-aggregation

Mysql DELETE FROM with subquery as condition

sql
delete
subquery
temporary-table

Remove the last character in a string in T-SQL?

sql
string-manipulation
null-handling
best-practices

How can I tell what edition of SQL Server runs on the machine?

sql
editionid
compatibility
database-management

How to view the SQL queries issued by JPA?

sql
jpa-logging
hibernate
eclipselink

Change Schema Name Of Table In SQL

sql
schema-transfer
dynamic-sql
error-handling

What is the difference between JOIN and UNION?

sql
join
union
data-consolidation

How to delete from a table where ID is in a list of IDs?

sql
delete
transactions
best-practices

Finding duplicate rows in SQL Server

sql
duplicates
inner-join
deletion

Where value in column containing comma delimited values

sql
comma-separated
data-normalization
wildcard-search

Copy Data from a table in one Database to another separate database

sql
data-migration
performance
bulk-operations

Efficient way to implement paging

sql
paging
performance
stored-procedures

Sqlite - replace part of a string

sql
string-manipulation
backup
custom-functions

How do you use script variables in psql?

sql
variables
sql-injection
postgresql

Using DISTINCT and COUNT together in a MySQL Query

sql
distinct
count
subqueries

In SQL, what's the difference between count(column) and count(*)?

sql
count
nulls
joins

How to use andWhere and orWhere in Doctrine?

sql
query-optimization
conditions
doctrine
explain.codes / Sql