select * from SQL Page 4 - DEV Community
https://dev.to/t/sql/page/4 • 144 KB fetched
Open original page
select * from SQL Page 4 - DEV Community
Skip to content
Powered by Algolia
Log in
Create account
DEV Community
select * from SQL
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Follow
Hide
Create Post
submission guidelines
Allowed
* Posts about learning SQL
* Posts about tips, tricks, problems, and answers
* Posts about news or commentary of the field
* Posts about specific tooling or frameworks
Think what would someone wanting to learn more about SQL want to see.
Not Allowed
* Articles that mention SQL in passing
* Articles that break the terms of use
about #sql
SQL is the language of data, has been for nearly 50 years now!
Older #sql posts
1
2
3
4
5
6
7
8
9
Posts
đź‘‹ Sign in for the ability to sort posts by relevant , latest , or top .
My SQL Learning Journey: The Sunrise Supermarket Project
Nelly Triza
Nelly Triza
Nelly Triza
Follow
Sep 7
My SQL Learning Journey: The Sunrise Supermarket Project
# beginners
# database
# learning
# sql
5 Â reactions
Add Comment
5 min read
Walking an Org Chart with One SQL Query
Rahman
Rahman
Rahman
Follow
Sep 7
Walking an Org Chart with One SQL Query
# sql
# postgres
# database
# tutorial
Add Comment
1 min read
Online Voting System in my facing challenges.....
Abinesh.R
Abinesh.R
Abinesh.R
Follow
Sep 6
Online Voting System in my facing challenges.....
# beginners
# java
# sql
# jdbc
1 Â reaction
Add Comment
2 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)
zgl-20053779
zgl-20053779
zgl-20053779
Follow
Sep 6
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)
# automation
# database
# opensource
# sql
Add Comment
5 min read
The hardest label in our dataset is the one where nothing happened
Aravind R
Aravind R
Aravind R
Follow
Sep 5
The hardest label in our dataset is the one where nothing happened
# datascience
# dataengineering
# analytics
# sql
Add Comment
14 min read
Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion
zgl-20053779
zgl-20053779
zgl-20053779
Follow
Sep 5
Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion
# automation
# database
# opensource
# sql
1 Â reaction
1 Â comment
2 min read
Recursive CTEs, explained from first principles
Cynthia Sophie Mwangi
Cynthia Sophie Mwangi
Cynthia Sophie Mwangi
Follow
Sep 4
Recursive CTEs, explained from first principles
# sql
# cte
# dataengineering
# datascience
3 Â reactions
2 Â comments
5 min read
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
Ama Senevirathne
Ama Senevirathne
Ama Senevirathne
Follow
Sep 4
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
# sql
# postgres
# distributedsystems
# architecture
Add Comment
3 min read
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
Arpit Bangre
Arpit Bangre
Arpit Bangre
Follow
Sep 4
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
# sql
# database
# dataengineering
# beginners
Add Comment
2 min read
Don't put an LLM in charge of your production database
Aniket Abhishek Soni
Aniket Abhishek Soni
Aniket Abhishek Soni
Follow
Sep 4
Don't put an LLM in charge of your production database
# sql
# llm
# data
# platform
Add Comment
5 min read
How to return top-N from each group with GROUP_CONCAT()
Sergey Nikolaev
Sergey Nikolaev
Sergey Nikolaev
Follow
Sep 4
How to return top-N from each group with GROUP_CONCAT()
# database
# sql
# opensource
# tutorial
Add Comment
6 min read
Three ways your dashboard can be correct and still lie
Rune Skarsfjor
Rune Skarsfjor
Rune Skarsfjor
Follow
Sep 4
Three ways your dashboard can be correct and still lie
# data
# sql
# webdev
# analytics
Add Comment
3 min read
Postgres earthdistance
David S
David S
David S
Follow
Sep 4
Postgres earthdistance
# database
# postgres
# sql
Add Comment
1 min read
SQLazy: Get the Latest Closed Before ConfirmationStarted
Judy
Judy
Judy
Follow
Sep 4
SQLazy: Get the Latest Closed Before ConfirmationStarted
# backend
# database
# sql
5 Â reactions
Add Comment
3 min read
SQL Is Surviving, Franklin: When Tables Start Talking
Faith Njenga
Faith Njenga
Faith Njenga
Follow
Sep 8
SQL Is Surviving, Franklin: When Tables Start Talking
# beginners
# database
# sql
# tutorial
2 Â reactions
Add Comment
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant , latest , or top .
DEV Community — A space to discuss and keep up software development and manage your software career
*
Home
*
DEV Challenges
*
DEV++
*
Videos
*
DEV Education Tracks
*
DEV Help
*
Advertise on DEV
*
Organization Accounts
*
DEV Showcase
*
About
*
Contact
*
Free Postgres Database
*
DEV Shop
*
MLH
*
Code of Conduct
*
Privacy Policy
*
Terms of Use
Built on Forem — the open source software that powers DEV and other inclusive communities.
Made with love and Ruby on Rails . DEV Community (c) 2016 - 2026.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account
Links found on this page
- Skip to content [direct]
- Powered by Algolia [direct]
- Log in [direct]
- Create account [direct]
- Create Post [direct]
- terms of use [direct]
- 1 [direct]
- 2 [direct]
- 3 [direct]
- 5 [direct]
- 6 [direct]
- 7 [direct]
- 8 [direct]
- 9 [direct]
- My SQL Learning Journey: The Sunrise Supermarket Project [direct]
- Nelly Triza [direct]
- # beginners [direct]
- # database [direct]
- # learning [direct]
- Walking an Org Chart with One SQL Query [direct]
- Rahman [direct]
- # postgres [direct]
- # tutorial [direct]
- Online Voting System in my facing challenges..... [direct]
- Abinesh.R [direct]
- # java [direct]
- # jdbc [direct]
- Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1) [direct]
- zgl-20053779 [direct]
- # automation [direct]
- # opensource [direct]
- The hardest label in our dataset is the one where nothing happened [direct]
- Aravind R [direct]
- # datascience [direct]
- # dataengineering [direct]
- # analytics [direct]
- Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion [direct]
- Recursive CTEs, explained from first principles [direct]
- Cynthia Sophie Mwangi [direct]
- # cte [direct]
- The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems [direct]
- Ama Senevirathne [direct]
- # distributedsystems [direct]
- # architecture [direct]
- SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps) [direct]
- Arpit Bangre [direct]
- Don't put an LLM in charge of your production database [direct]
- Aniket Abhishek Soni [direct]
- # llm [direct]
- # data [direct]
- # platform [direct]
- How to return top-N from each group with GROUP_CONCAT() [direct]
- Sergey Nikolaev [direct]
- Three ways your dashboard can be correct and still lie [direct]
- Rune Skarsfjor [direct]
- # webdev [direct]
- Postgres earthdistance [direct]
- David S [direct]
- SQLazy: Get the Latest Closed Before ConfirmationStarted [direct]
- Judy [direct]
- # backend [direct]
- SQL Is Surviving, Franklin: When Tables Start Talking [direct]
- Faith Njenga [direct]
- DEV Community [direct]
- DEV Challenges [direct]
- DEV++ [direct]
- Videos [direct]
- DEV Education Tracks [direct]
- DEV Help [direct]
- Advertise on DEV [direct]
- Organization Accounts [direct]
- DEV Showcase [direct]
- About [direct]
- Contact [direct]
- Free Postgres Database [direct]
- DEV Shop [direct]
- MLH [direct]
- Code of Conduct [direct]
- Privacy Policy [direct]
- Forem [direct]
|
|