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.
I want to manually delete rows, so tell me about all referenced tables

I want to manually delete rows, so tell me about all referenced tables

6
Comments
1 min read
PIVOT-UNPIVOT

PIVOT-UNPIVOT

7
Comments
1 min read
Flask app with postgreSQL

Flask app with postgreSQL

6
Comments
1 min read
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

11
Comments 1
15 min read
Oracle Cheat Sheet

Oracle Cheat Sheet

43
Comments 2
5 min read
What is Stored Procedure in SQL

What is Stored Procedure in SQL

6
Comments
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

5
Comments
5 min read
Loading Test Data into PostgreSQL

Loading Test Data into PostgreSQL

6
Comments 1
9 min read
Custom traits in Apache Calcite

Custom traits in Apache Calcite

4
Comments
7 min read
Combining SQL outer joins with inner joins

Combining SQL outer joins with inner joins

5
Comments
2 min read
Getting started with PostgreSQL Set Operators

Getting started with PostgreSQL Set Operators

7
Comments
4 min read
Quick-start SQL Server 2019 in Docker

Quick-start SQL Server 2019 in Docker

4
Comments
1 min read
Popular string functions in MySQL - Replace and Reverse

Popular string functions in MySQL - Replace and Reverse

4
Comments
1 min read
Using SQL or NoSQL

Using SQL or NoSQL

7
Comments 3
1 min read
Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

4
Comments
4 min read
Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

5
Comments
2 min read
Programming with SQLite

Programming with SQLite

5
Comments
2 min read
TypeORM - Multiple DB Calls vs Single DB Call

TypeORM - Multiple DB Calls vs Single DB Call

15
Comments
6 min read
Can I get a dash of regular expression in my KQL?

Can I get a dash of regular expression in my KQL?

7
Comments
1 min read
3 small tips to make your SQL Server experience easier

3 small tips to make your SQL Server experience easier

8
Comments
5 min read
How To Find Unused Stored Procedures In SQL Server

How To Find Unused Stored Procedures In SQL Server

7
Comments
3 min read
Postgres Full Text Search

Postgres Full Text Search

4
Comments
5 min read
SQL Review - Useful queries for mySQL

SQL Review - Useful queries for mySQL

9
Comments
1 min read
What is SQL - Part 4

What is SQL - Part 4

7
Comments
7 min read
Building a Hybrid SQL + NoSQL E-Commerce Data Model

Building a Hybrid SQL + NoSQL E-Commerce Data Model

22
Comments
7 min read
loading...