Explain Codes LogoExplain Codes Logo

Sql

Is it possible to output a SELECT statement from a PL/SQL block?

sql
prompt-engineering
best-practices
pipelined-functions

Recommended SQL database design for tags or tagging

sql
database-design
performance-optimization
indexing

Sql query to select distinct row with minimum value

sql
window-functions
sql-queries
performance-optimization

Database/sql Tx - detecting Commit or Rollback

sql
transaction-management
error-handling
database-operations

When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

sql
timestamp
database-management
performance-optimization

Synchronizing client-server databases

sql
conflict-resolution
data-synchronization
database-design

How do I write LINQ's .Skip(1000).Take(100) in pure SQL?

sql
pagination
performance-optimization
sql-queries

How to select the last record from a MySQL table using SQL syntax

sql
join
best-practices
performance

What is the difference between `->` and `->>` in Postgres SQL?

sql
json
data-handling
performance

How to get the first and last record from an SQL query?

sql
window-functions
performance-tuning
query-optimization

Best way to create a temp table with same columns and type as a permanent table

sql
temp-tables
sql-server
postgresql

Mysql "WITH" clause

sql
cte
mysql
performance

Does the order of where clauses matter in SQL?

sql
query-optimization
database-performance
sql-indexes

Case .. WHEN expression in Oracle SQL

sql
case-statement
oracle-sql
sql-queries

Can I change the default schema name in entity framework 4.3 code-first?

sql
entity-framework
schema-configuration
fluent-api

Using If else in SQL Select statement

sql
best-practices
case-statement
sql-performance

What is (are) the differences between NOLOCK and UNCOMMITTED

sql
transaction-isolation
dirty-reads
locking-mechanisms

Can I reuse a calculated field in a SELECT query?

sql
sql-calculations
performance-optimization
sql-optimization

How to return the output of a stored procedure into a variable in SQL Server

sql
stored-procedures
output-parameters
temp-tables

Mysql: Compare differences between two tables

sql
join
union-all
information-schema
explain.codes / Sql