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.
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

25
Comments
3 min read
SQL: Doing GROUP BY in CsvPath

SQL: Doing GROUP BY in CsvPath

Comments
5 min read
SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

4
Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

25
Comments
3 min read
Craft and Control Resource Pools on MSSQL

Craft and Control Resource Pools on MSSQL

Comments
3 min read
Subquery to GROUP JOIN — A Method for Merging Multiple Subqueries

Subquery to GROUP JOIN — A Method for Merging Multiple Subqueries

Comments 1
5 min read
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

24
Comments
2 min read
dev14

dev14

Comments
1 min read
step6

step6

Comments
1 min read
step4

step4

Comments
1 min read
step3

step3

Comments
2 min read
step2

step2

Comments
1 min read
CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

Comments
5 min read
Databases & SQL Basics As A Beginner: A Practical Introduction

Databases & SQL Basics As A Beginner: A Practical Introduction

26
Comments 1
3 min read
cursor5

cursor5

Comments
1 min read
I Built SQLTranslate: An AI-Powered Tool to Convert SQL Between Database Dialects

I Built SQLTranslate: An AI-Powered Tool to Convert SQL Between Database Dialects

Comments 1
2 min read
The road to SeaQuery 1.0

The road to SeaQuery 1.0

2
Comments 1
11 min read
A Sneak Peek at SeaORM 2.0

A Sneak Peek at SeaORM 2.0

Comments
7 min read
compare7

compare7

Comments
1 min read
compare3

compare3

Comments
1 min read
Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination

Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination

1
Comments
2 min read
pg-status - a lightweight microservice for checking PostgreSQL host status

pg-status - a lightweight microservice for checking PostgreSQL host status

Comments
7 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
How to Learn SQL for Data Analysis in 2026: A Free Learning Path

How to Learn SQL for Data Analysis in 2026: A Free Learning Path

Comments
2 min read
How to Read SQL Server Execution Plans: 7 Things That Matter

How to Read SQL Server Execution Plans: 7 Things That Matter

4
Comments
10 min read
loading...