Explain Codes LogoExplain Codes Logo

Sql

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

Can MySQL convert a stored UTC time to local timezone?

sql
mysql
timezone
performance

How to insert a record into a table with a column declared with the SERIAL function

sql
best-practices
performance
concurrent-inserts

How to get the size of a varchar[n] field in one SQL statement?

sql
database-schema-management
varchar-field-size
information-schema

How to export a MySQL database to JSON?

sql
mysql
json
data-export

Unioning two tables with different number of columns

sql
union
data-types
sql-variants

Postgresql: Create schema in specific database

sql
database-management
schema-creation
postgresql

Sql: Capitalize First Letter Only

sql
string-manipulation
custom-functions
xml-and-nodes

How to remove unique key from MySQL table

sql
database-backup
index-operations
sql-queries

How can I merge two MySQL tables?

sql
data-integrity
database-management
sql-queries

Can we pass parameters to a view in SQL?

sql
udf
stored-procedures
session-context

Sql Server: Cannot insert an explicit value into a timestamp column

sql
data-types
datetime
timestamp

Mysql "CREATE TABLE IF NOT EXISTS" -> Error 1050

sql
database-performance
data-integrity
best-practices
explain.codes / Sql