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.
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

5
Comments
1 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
Comments
1 min read
The script of AGE (ch. 01)

The script of AGE (ch. 01)

2
Comments
4 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

Comments
8 min read
AEM: Connect AEM to an External database (Oracle example)

AEM: Connect AEM to an External database (Oracle example)

Comments
5 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
Comments
1 min read
Quem é melhor? ORM ou SQL puro?

Quem é melhor? ORM ou SQL puro?

3
Comments 1
9 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why

SQL Versus NoSQL Databases: Which to Use, When, and Why

16
Comments
9 min read
Stored Procedures in SQL database

Stored Procedures in SQL database

2
Comments
2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

15
Comments
5 min read
Transactions - difference between SQL, SQLAlchemy and Django ORM

Transactions - difference between SQL, SQLAlchemy and Django ORM

Comments
2 min read
Simplest pyspark tutorial

Simplest pyspark tutorial

2
Comments
7 min read
Cloud ETL Pipeline in Azure

Cloud ETL Pipeline in Azure

1
Comments
8 min read
SQL 102:Intermediate SQL

SQL 102:Intermediate SQL

Comments
10 min read
SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

2
Comments
3 min read
When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

5
Comments
2 min read
Loop on static content to upsert many rows in Oracle SQL

Loop on static content to upsert many rows in Oracle SQL

1
Comments
1 min read
Performance Enhancement: Conversion Funnel Analysis

Performance Enhancement: Conversion Funnel Analysis

Comments
9 min read
Quick and Handy Tips for Everyday PostgreSQL Tasks

Quick and Handy Tips for Everyday PostgreSQL Tasks

1
Comments
2 min read
🔄 Self-reference Laravel Model

🔄 Self-reference Laravel Model

6
Comments
3 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
Apache AGE:A quick overview.

Apache AGE:A quick overview.

3
Comments
1 min read
Scalable bounded COUNT DISTINCT in YugabyteDB

Scalable bounded COUNT DISTINCT in YugabyteDB

Comments
6 min read
All about Structure Query Language (SQL)

All about Structure Query Language (SQL)

Comments
10 min read
loading...