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.
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)
arpitmbangre profile

Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

#sql #datascience #database #dataengineering
Comments
2 min read
How to Master Intermediate SQL in Under 10 Minutes
rahmanfrr profile
Rahman

How to Master Intermediate SQL in Under 10 Minutes

#sql #database #tutorial #programming
Comments
5 min read
'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That
systemcraftdev profile

'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That

#sql #database #beginners #tutorial
Comments
3 min read
SQL Window Functions Explained
opaul profile

SQL Window Functions Explained

#backend #database #sql
Comments
4 min read
Connecting Power BI to SQL Databases
suzanne_orido profile

Connecting Power BI to SQL Databases

#database #postgres #sql
Comments
10 min read
Mastering SQL Joins and Window Functions: A Comprehensive Guide
suzanne_orido profile

Mastering SQL Joins and Window Functions: A Comprehensive Guide

#data #database #sql #tutorial
Comments
4 min read
LIKE in SQL, Explained for Beginners
michaelnocito profile

LIKE in SQL, Explained for Beginners

#sql #database #tutorial #beginners
Comments
7 min read
Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.
okall_omondi profile

Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.

#sql #programming #beginners #tutorial
Comments
6 min read
Ottoch - ask your database questions in you plain language, self-hosted....
santhosh_bhandari_aee9f66 profile

Ottoch - ask your database questions in you plain language, self-hosted....

#showdev #ai #sql #opensource
Comments
1 min read
SQL PRACTICAL GUIDE
karen_wangui_ profile

SQL PRACTICAL GUIDE

#sql #datascience
Comments
4 min read
SQL vs. NoSQL — stop asking the wrong question
vladut02 profile
VLAD

SQL vs. NoSQL — stop asking the wrong question

#sql #nosql #database #mongodb
1
Comments
4 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)
zgl20053779 profile

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

#productivity #opensource #database #sql
Comments
6 min read
Your text-to-SQL agent picks tables before security runs. Here’s the fix.
ashish_sinha_5241c7673d93 profile

Your text-to-SQL agent picks tables before security runs. Here’s the fix.

#ai #python #sql #opensource
Comments 4
2 min read
When SQL Has Nothing to Say: Understanding NULLs
rose_odiwuor profile

When SQL Has Nothing to Say: Understanding NULLs

#sql
Comments
3 min read
SQL for Beginners: Window Functions vs GROUP BY
mysticg profile

SQL for Beginners: Window Functions vs GROUP BY

#sql #ai #programming #productivity
2
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.