Forem

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.
How to Delete Duplicate Data from a MySQL Database

How to Delete Duplicate Data from a MySQL Database

Comments
4 min read
Group and Summarize data, and align to the specified sequence #eg31

Group and Summarize data, and align to the specified sequence #eg31

6
Comments
1 min read
List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

14
Comments 1
1 min read
Common Table Expression (CTE) in PLSQL | Part 1

Common Table Expression (CTE) in PLSQL | Part 1

5
Comments
6 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Cover image for Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

25
Comments
7 min read
SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

8
Comments
3 min read
Boosting PostgreSQL Performance: Optimising Queries with the != Operator
Cover image for Boosting PostgreSQL Performance: Optimising Queries with the != Operator

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

4
Comments
8 min read
How to create a table with SQL code?
Cover image for How to create a table with SQL code?

How to create a table with SQL code?

3
Comments
6 min read
SQL, extract unique values of JSON format field from each group #eg42

SQL, extract unique values of JSON format field from each group #eg42

6
Comments
2 min read
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
Cover image for Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

1
Comments
4 min read
How to Downsample Your Data Efficiently

How to Downsample Your Data Efficiently

Comments
2 min read
Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
Cover image for Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!

Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!

13
Comments 3
3 min read
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
Cover image for Turbocharge Your App: Slash DB Calls with Raw SQL Magic!

Turbocharge Your App: Slash DB Calls with Raw SQL Magic!

4
Comments
2 min read
Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

4
Comments
3 min read
CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

1
Comments
2 min read
How to send a message to Slack workspace members using an SQL statement

How to send a message to Slack workspace members using an SQL statement

Comments
2 min read
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
Cover image for Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

Comments
3 min read
Logical Processing order of a SQL query

Logical Processing order of a SQL query

9
Comments 2
4 min read
DbVisualizer 24.2: A Complete Review
Cover image for DbVisualizer 24.2: A Complete Review

DbVisualizer 24.2: A Complete Review

10
Comments
11 min read
PL/SQL Cursors

PL/SQL Cursors

2
Comments 2
4 min read
PL/SQL Triggers

PL/SQL Triggers

1
Comments
3 min read
Deleting Duplicate Data from MySQL

Deleting Duplicate Data from MySQL

1
Comments
3 min read
Different ways of working with SQL Databases in Go
Cover image for Different ways of working with SQL Databases in Go

Different ways of working with SQL Databases in Go

2
Comments
9 min read
PLSQL Top 10 Interview Questions

PLSQL Top 10 Interview Questions

2
Comments
4 min read
How data is replicated in slave nodes in SQL databases
Cover image for How data is replicated in slave nodes in SQL databases

How data is replicated in slave nodes in SQL databases

Comments
3 min read
loading...