close
The Wayback Machine - https://web.archive.org/web/20230330083435/https://dev.to/t/sql

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.
Simple query for remove duplicates from table

Simple query for remove duplicates from table

Image 2
Comments
2 min read
SQL Server Performance Tuning

SQL Server Performance Tuning

Image 2
Comments
2 min read
Structure Query Language

Structure Query Language

Image Image Image Image Image 6
Comments
2 min read
Millions record query - with and without index

Millions record query - with and without index

Comments
2 min read
How to validate your prisma raw query results

How to validate your prisma raw query results

Image 1
Comments
2 min read
How to use sequel.ai to convert natural language queries into SQL queries

How to use sequel.ai to convert natural language queries into SQL queries

Comments
3 min read
YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

Image 1
Comments
2 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

Image 3
Comments 2
3 min read
How to choose the right streaming database

How to choose the right streaming database

Image Image Image Image Image 12
Comments
7 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

Comments
3 min read
Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Comments 1
5 min read
[GDB] Debugging session PostgreSQL & AGE

[GDB] Debugging session PostgreSQL & AGE

Image 3
Comments
1 min read
Query Real Time Data in Kafka Using SQL

Query Real Time Data in Kafka Using SQL

Image Image Image Image Image 6
Comments
9 min read
DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

Comments
2 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Image 1
Comments
2 min read
How to write an anonymous PL/SQL function and use it in your SQL statement

How to write an anonymous PL/SQL function and use it in your SQL statement

Comments
3 min read
Getting Started With SQL

Getting Started With SQL

Image Image 5
Comments
4 min read
Full-text search com PostgreSQL

Full-text search com PostgreSQL

Comments
9 min read
Scalable sequences in PostgreSQL / YugabyteDB

Scalable sequences in PostgreSQL / YugabyteDB

Comments
3 min read
Essential SQL Commands for Data Science Tasks

Essential SQL Commands for Data Science Tasks

Image 2
Comments
7 min read
Save $ on public S3 buckets using VPC endpoints via SQL

Save $ on public S3 buckets using VPC endpoints via SQL

Comments
6 min read
ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

Comments
6 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

Image 1
Comments 1
7 min read
Insight Findings from A Case Study of Customers Leaving Credit Card Services

Insight Findings from A Case Study of Customers Leaving Credit Card Services

Comments
10 min read
CITEXT vs LOWER

CITEXT vs LOWER

Comments
4 min read
Retype a column in YugabyteDB (and PostgreSQL)

Retype a column in YugabyteDB (and PostgreSQL)

Image 3
Comments
5 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Image Image Image Image Image 71
Comments 16
7 min read
SQL Concepts

SQL Concepts

Image 1
Comments
11 min read
SQL Concepts

SQL Concepts

Image 1
Comments
6 min read
Practicing String Manipulation in SQL

Practicing String Manipulation in SQL

Image 2
Comments
7 min read
A Practical Guide to SQL Dates with DuckDB.

A Practical Guide to SQL Dates with DuckDB.

Comments 2
9 min read
Hacking 101: Common Attacks and How to Stop Them

Hacking 101: Common Attacks and How to Stop Them

Image 1
Comments
5 min read
Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

Image 4
Comments
5 min read
Infra as SQL is in beta

Infra as SQL is in beta

Image 1
Comments
4 min read
Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

Image Image 3
Comments 1
5 min read
Essential SQL Concepts

Essential SQL Concepts

Comments
12 min read
SQL Concepts

SQL Concepts

Image 1
Comments
14 min read
General Questions

General Questions

Image 1
Comments
5 min read
Deeply Nested XML and JSON with SQL

Deeply Nested XML and JSON with SQL

Comments
3 min read
Use ChatGPT to convert function to SQL query

Use ChatGPT to convert function to SQL query

Comments
2 min read
When to use window functions over group by in SQL?

When to use window functions over group by in SQL?

Comments
3 min read
SQL JOIN explained

SQL JOIN explained

Image Image Image Image Image 65
Comments 3
13 min read
sqlite / sqlx + async

sqlite / sqlx + async

Image 1
Comments
2 min read
Supabase: count and discount raws from the likes table

Supabase: count and discount raws from the likes table

Image 2
Comments
2 min read
Reading and Writing Files in SQLite

Reading and Writing Files in SQLite

Image 1
Comments
4 min read
SQL-DATA ANALYSIS,AN INTRODUCTION

SQL-DATA ANALYSIS,AN INTRODUCTION

Image 3
Comments
6 min read
Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

Image 1
Comments
6 min read
A Tutorial on SQL Window Functions.

A Tutorial on SQL Window Functions.

Image 1
Comments
15 min read
Data Business Logic In Java: jOOQ VS SPL

Data Business Logic In Java: jOOQ VS SPL

Image 2
Comments
4 min read
Record Insert with Relational Validation in One SQL Statement

Record Insert with Relational Validation in One SQL Statement

Image Image Image 3
Comments
7 min read
Optimizing Database Performance: Exploring Indexing Techniques in DBMS

Optimizing Database Performance: Exploring Indexing Techniques in DBMS

Image Image Image Image Image 11
Comments
16 min read
How to limit the number of connections per DB in the PostgreSQL?

How to limit the number of connections per DB in the PostgreSQL?

Comments
1 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Image 1
Comments
6 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
6 min read
Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases

Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases

Image 1
Comments
5 min read
PostgreSQL SELECT STATEMENT.

PostgreSQL SELECT STATEMENT.

Comments
1 min read
ChatGPT - Complex Coding Challenges: 7 KYU

ChatGPT - Complex Coding Challenges: 7 KYU

Image 2
Comments
2 min read
Columns to Rows in Oracle SQL

Columns to Rows in Oracle SQL

Comments
4 min read
Free AWS BootCamp WEEK 4: SQL Databases

Free AWS BootCamp WEEK 4: SQL Databases

Image 1
Comments
5 min read
Useful SQL Commands

Useful SQL Commands

Image 2
Comments
4 min read
loading...