Subqueries
When to Use
May 14, 20251 min read8
Command Palette
Search for a command to run...
#sql
Articles tagged with #sql
Self-Joins
When to Use
May 14, 20251 min read6Window Functions
Aggregate Functions (Used for calculations over a set of rows) SUM(): Calculates the sum of values over a window. AVG(): Calculates the average of values. MIN(): Finds the minimum value. MAX(): Finds the maximum value. COUNT(): Counts rows over ...
May 14, 20252 min read4Common Table Expressions (CTEs)
When to Use
May 14, 20251 min read8SQL Query Optimization Techniques
Indexing Create indexes on columns frequently used in WHERE, JOIN and ORDER BY clauses for faster lookups. Avoid SELECT * Select only the necessary columns instead of using SELECT * to reduce the amount of data retrieved. Query Execution Plan Analysi...
May 14, 20252 min read9Renaming SQL Developer Worksheets
thatjeffsmith.com/archive/2012/08/sql-developer-trick-renaming-your-worksheets -- execute (ctrl+enter) as a single line (no semicolon) SET worksheetname NAME
Aug 8, 20241 min read8