DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
arpitmbangre profile

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

#sql #database #dataengineering #beginners
Comments
2 min read
How to return top-N from each group with GROUP_CONCAT()
sanikolaev profile

How to return top-N from each group with GROUP_CONCAT()

#database #sql #opensource #tutorial
Comments
6 min read
Three ways your dashboard can be correct and still lie
sprettball profile

Three ways your dashboard can be correct and still lie

#data #sql #webdev #analytics
Comments
3 min read
SQLazy: Get the Latest Closed Before ConfirmationStarted
esproc_spl profile
Judy

SQLazy: Get the Latest Closed Before ConfirmationStarted

#backend #database #sql
5
Comments
3 min read
Start and End Dates of the Longest Rising Period
esproc_spl profile
Judy

Start and End Dates of the Longest Rising Period

#algorithms #computerscience #database #sql
5
Comments 1
6 min read
How we put 16 database engines behind one result grid
yusufgundogdu profile

How we put 16 database engines behind one result grid

#database #opensource #sql #webdev
Comments
6 min read
🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance
mindinu profile

🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance

#ai #webdev #productivity #sql
10
Comments
3 min read
When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots
dataio_4921 profile

When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots

#postgres #sql #ai #security
Comments
8 min read
Ranking a Two-Dimensional Catalog With One SQL Expression
citationbuilder profile

Ranking a Two-Dimensional Catalog With One SQL Expression

#sql #postgres #webdev #database
Comments
5 min read
SQL Basics: A Real-World Guide to Databases and Queries
harshitha_madhavarapu profile

SQL Basics: A Real-World Guide to Databases and Queries

#sql #database #beginners #tutorial
Comments
4 min read
SQL Interview Questions (With Model Answers)
peakblick profile

SQL Interview Questions (With Model Answers)

#sql #beginners #interview #database
Comments 1
4 min read
SQL Starters
kalyanam_venumadhav_aaddf profile

SQL Starters

#sql #sqlserver #database #mysql
Comments
2 min read
The Data Modeling Concepts Nobody Mentions After Star Schema 101
rahmanfrr profile

The Data Modeling Concepts Nobody Mentions After Star Schema 101

#dataengineering #datamodeling #sql #tutorial
1
Comments
6 min read
How I stopped manually rebuilding Java PreparedStatement SQL
olimar50 profile

How I stopped manually rebuilding Java PreparedStatement SQL

#java #sql #jdbc #webdev
Comments
2 min read
Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number
systemcraftdev profile

Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number

#sql #database #beginners #tutorial
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.