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.
Difference between WHERE vs HAVING Clause in SQL
somadevtoo profile
Soma

Difference between WHERE vs HAVING Clause in SQL

#sql #database #programming #development
42
Comments 1
3 min read
SQL Injection Isn't Dead Yet
codemouse92 profile

SQL Injection Isn't Dead Yet

#security #sql
35
Comments 1
6 min read
Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval
emtiajium profile

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

#postgres #sql
32
Comments 1
4 min read
Mastering SQL Queries: A Comprehensive Guide for Beginners
tinapyp profile

Mastering SQL Queries: A Comprehensive Guide for Beginners

#sql #datascience #database #beginners
25
Comments 5
2 min read
How I migrated from Firebase to Supabase
ja profile

How I migrated from Firebase to Supabase

#postgres #sql #firebase #webdev
17
Comments 2
5 min read
Using migrations with Golang
wiliamvj profile

Using migrations with Golang

#go #sql #tutorial #beginners
15
Comments
5 min read
How to Replace a Null with the Corresponding Value in the Previous Record
esproc_spl profile
Judy

How to Replace a Null with the Corresponding Value in the Previous Record

#sql #development #database #laugange
6
Comments 1
1 min read
Calculate the Total Price According to the Cumulative Price Table
esproc_spl profile
Judy

Calculate the Total Price According to the Cumulative Price Table

#sql #database #development #laugenge
6
Comments 3
1 min read
Types of equi-joins
esproc_spl profile
Judy

Types of equi-joins

#sql #join #eaui #development
6
Comments 1
4 min read
What is the Difference between "sequel" and "SQL"?
thekarlesi profile

What is the Difference between "sequel" and "SQL"?

#webdev #beginners #programming #sql
6
Comments 6
1 min read
About transaction identifier (transaction_id) in PostgreSQL.
dm8ry profile

About transaction identifier (transaction_id) in PostgreSQL.

#postgres #devops #database #sql
6
Comments
2 min read
In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes
esproc_spl profile
Judy

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

#sql #database #development #language
5
Comments 1
1 min read
JOINs in SQL
esproc_spl profile
Judy

JOINs in SQL

#sql #join #development #langange
5
Comments 1
5 min read
How to Calculate Median on Values That Have Corresponding Quantities
esproc_spl profile
Judy

How to Calculate Median on Values That Have Corresponding Quantities

#sql #database #development #laugunge
5
Comments
2 min read
How to Transpose Rows to Columns on Multiple Fields in Each Group
esproc_spl profile
Judy

How to Transpose Rows to Columns on Multiple Fields in Each Group

#sql #database #data #development
5
Comments 1
2 min read
Dimension alignment
esproc_spl profile
Judy

Dimension alignment

#sql #development #join #programming
5
Comments 1
4 min read
Practical Experiments for Optimizing Django query with the power of SQL joins
wewake-dev profile

Practical Experiments for Optimizing Django query with the power of SQL joins

#django #optimization #performance #sql
5
Comments
7 min read
SQL | DDL, DQL, DML, DCL and TCL Commands
rakeshvngowda profile

SQL | DDL, DQL, DML, DCL and TCL Commands

#sql #database
5
Comments
2 min read
Introducing Filterable: Simplify Data Handling in Your Laravel Applications
thavarshan profile

Introducing Filterable: Simplify Data Handling in Your Laravel Applications

#laravel #webdev #sql #php
4
Comments
7 min read
Easy no-code REST API for your databases
thadguidry profile

Easy no-code REST API for your databases

#restapi #sql #database #opensource
3
Comments 2
3 min read
Oracle Database - Compare Execution Plans
abhilash8 profile

Oracle Database - Compare Execution Plans

#oracle #oci #database #sql
3
Comments
5 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?
dm8ry profile

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

#postgres #database #sql #howto
3
Comments 1
2 min read
The best type for storing money in our posgresql db
thecoder512 profile

The best type for storing money in our posgresql db

#webdev #sql #backend #postgressql
3
Comments
2 min read
Understanding of NULL in PostgreSQL database.
dm8ry profile

Understanding of NULL in PostgreSQL database.

#postgressql #database #sql #howto
3
Comments
2 min read
Predicate Pushdown - Understanding Practically With An Example
anikethsdeshpande profile

Predicate Pushdown - Understanding Practically With An Example

#spark #optimisation #sql #interview
3
Comments 1
2 min read
Common Table Expressions (CTEs) in SQL
johnkyalo profile

Common Table Expressions (CTEs) in SQL

#database #datascience #sql #analytics
3
Comments
1 min read
Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service
mayanksahai profile

Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service

#athena #aws #serverless #sql
3
Comments
3 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.
dm8ry profile

PostgreSQL: Deleting all records from a table, except for the first and last ones.

#postgres #database #sql #data
2
Comments
2 min read
Why MongoDB is not great for complex reporting?
kwnaidoo profile

Why MongoDB is not great for complex reporting?

#discuss #mongodb #sql #database
2
Comments
1 min read
What is SQL in picture
onumaku_bobby profile

What is SQL in picture

#sql #datascience #softwaredevelopment
2
Comments 2
1 min read
Say No to SQL đź™…
itskunal profile

Say No to SQL đź™…

#database #redis #sql #devops
2
Comments
3 min read
Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)
abhilash8 profile

Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

#oracle #sql #database #debug
2
Comments
5 min read
Understanding SQL vs. NoSQL Databases: A Beginner's Guide
henrylehd profile

Understanding SQL vs. NoSQL Databases: A Beginner's Guide

#sql #beginners #database #nosql
2
Comments
2 min read
JOINS IN SQL
johnkyalo profile

JOINS IN SQL

#datascience #database #sql #data
2
Comments
2 min read
Custom SQL Scripts in PostgreSQL PgBench
franckpachot profile

Custom SQL Scripts in PostgreSQL PgBench

#postgres #pgbench #sql #database
2
Comments
6 min read
Using Temporary Tables in MariaDB
alejandro_du profile

Using Temporary Tables in MariaDB

#mariadb #sql #database #tips
1
Comments
2 min read
Statistical information about tables in a PostgreSQL Database.
dm8ry profile

Statistical information about tables in a PostgreSQL Database.

#postgres #database #sql #devops
1
Comments
2 min read
What is SQL in pictures. Diving deeper (Part 2)
onumaku_bobby profile

What is SQL in pictures. Diving deeper (Part 2)

#sql #datascience
1
Comments
2 min read
Move Fast and “Branch” Things
siegerts profile

Move Fast and “Branch” Things

#database #sql #fullstack #postgres
1
Comments
8 min read
Python and SQL: Objects in Programming
whoamivoyager profile

Python and SQL: Objects in Programming

#python #sql #webdev #beginners
1
Comments
3 min read
Advanced SQL Techniques: Take Next Level with CTE and SubQueries
tinapyp profile

Advanced SQL Techniques: Take Next Level with CTE and SubQueries

#sql #datascience #database #beginners
1
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?
dm8ry profile

How to join tables in PostgreSQL using the WITH clause?

#postgres #database #sql #howto
1
Comments
2 min read
A Software Engineer's Tips and Tricks #1: Drizzle
alisdairbr profile

A Software Engineer's Tips and Tricks #1: Drizzle

#webdev #sql #orm #tutorial
1
Comments 1
2 min read
Top 10 most asked SQL interview questions along with their answers
nikhilxd profile

Top 10 most asked SQL interview questions along with their answers

#sql #database #computerscience #career
1
Comments 1
3 min read
Week 1: New NOTR Server - Containerization and Data Storage
aldoportillo profile

Week 1: New NOTR Server - Containerization and Data Storage

#sql #docker #aws #postgres
1
Comments
3 min read
SQL DATA MANIPULATION
marklouisalter profile

SQL DATA MANIPULATION

#sql #database #mysql #postgressql
1
Comments
3 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!
yisakt profile

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

#sql #database #personalfinance
1
Comments
2 min read
Fetching Data (Next.js)
samuellubliner profile

Fetching Data (Next.js)

#webdev #javascript #sql #nextjs
1
Comments
2 min read
Simulate Clock Skew in Docker Container
franckpachot profile

Simulate Clock Skew in Docker Container

#yugabytedb #distributed #sql #database
1
Comments
2 min read
Finding Which Columns Value Has Actually Changed in PostgreSQL Trigger Functions
blugreenspace profile

Finding Which Columns Value Has Actually Changed in PostgreSQL Trigger Functions

#sql #tutorial #programming
1
Comments
2 min read
Tips and Tricks for Troubleshooting ClickHouse Wait Events
shiviyer profile

Tips and Tricks for Troubleshooting ClickHouse Wait Events

#clickhouse #sql #sqltips #dba
1
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?
dm8ry profile

How to find the third and fifth-highest values in a PostgreSQL table?

#postgres #database #howto #sql
1
Comments
2 min read
How to Back Up and Restore Azure SQL Databases
alex_tray profile

How to Back Up and Restore Azure SQL Databases

#azure #sql #database #backup
1
Comments
8 min read
How to Secure Your Supabase Database and Storage
cp_nandani profile

How to Secure Your Supabase Database and Storage

#webdev #sql #database #beginners
Comments
6 min read
Mastering SQL WHERE statement with dbForge Studio for SQL Server
devartteam profile

Mastering SQL WHERE statement with dbForge Studio for SQL Server

#sql #sqlserver #devart #dbforge
Comments
1 min read
Inside GmOwl: A Guide to Quiz Functionality
intersystemsdev profile

Inside GmOwl: A Guide to Quiz Functionality

#java #sql #tools #beginners
Comments
2 min read
Mastering Conversations: A Guide to Building and Using a Java-Based Chat (StarChat) with IRIS Cloud SQL.
intersystemsdev profile

Mastering Conversations: A Guide to Building and Using a Java-Based Chat (StarChat) with IRIS Cloud SQL.

#jdbc #sql #cloud #java
Comments
3 min read
Quick SQL guide and cheat sheet: Essential Commands
dbvismarketing profile

Quick SQL guide and cheat sheet: Essential Commands

#sql
Comments
1 min read
What’s New in Blazor Query Builder: 2024 Volume 1
jollenmoyani profile

What’s New in Blazor Query Builder: 2024 Volume 1

#blazor #csharp #development #sql
Comments
8 min read
Effective Annotating of Strace Output for MySQL Performance Troubleshooting
shiviyer profile

Effective Annotating of Strace Output for MySQL Performance Troubleshooting

#mysql #sqltips #sql #dba
Comments
4 min read
loading...