Explain Codes LogoExplain Codes Logo

Sql

I want to use CASE statement to update some records in SQL Server 2005

sql
join
case-statement
update-queries

What is the difference between single quotes and double quotes in PostgreSQL?

sql
best-practices
sql-queries
database-management

Sql query to get most recent row for each instance of a given key

sql
prompt-engineering
best-practices
performance

Sql - many-to-many table primary key

sql
data-integrity
indexing-strategies
orm-tools

Jdbc ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

sql
datetime
jdbc
timestamp

Counting number of joined rows in left join

sql
join
best-practices
performance

When should I use stored procedures?

sql
database-security
performance-optimization
best-practices

I want to show all tables that have specified column name

sql
database-agnostic
sql-queries
metadata

How do you drop a default value or similar constraint in T-SQL?

sql
prompt-engineering
best-practices
sql-server

Sql Server Script to create a new user

sql
sql-server
database-creation
user-management

"data too long for column" - why?

sql
data-types
encoding
database-design

Mysql combine two columns into one column

sql
concatenation
string-manipulation
sql-best-practices

Sql Query to get column values that correspond with MAX value of another column?

sql
subqueries
scalar-aggregate-reduction
window-functions

Counting number of grouped rows in MySQL

sql
subqueries
sql-performance
database-optimization

How to insert datetime into the SQL Database table?

sql
datetime
parameterized-queries
sql-injection

How to group by week in postgresql

sql
prompt-engineering
join
dataframe

Postgresql: Sub-select inside insert

sql
sub-select
insert
postgresql

Sql: How to replace values of select return?

sql
data-analytics
machine-learning
sql-queries

How do I view my stored procedures in phpMyAdmin?

sql
database-management
phpmyadmin
stored-procedures

Select something that has more/less than x character

sql
performance-tuning
sql-queries
database-performance
explain.codes / Sql