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.
.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

1
Comments
4 min read
Why should you upgrade your PostgreSQL today?

Why should you upgrade your PostgreSQL today?

1
Comments 1
3 min read
MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples

MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples

Comments
5 min read
Stored Procedure in PL/SQL

Stored Procedure in PL/SQL

2
Comments
2 min read
Best PostgreSQL Queries/Functions for Daily Operations

Best PostgreSQL Queries/Functions for Daily Operations

2
Comments 2
4 min read
Java, perform COUNT on each group of a large csv file #eg33

Java, perform COUNT on each group of a large csv file #eg33

6
Comments
2 min read
Open sourcing our new Text-to-SQL LLM app starter template

Open sourcing our new Text-to-SQL LLM app starter template

1
Comments
6 min read
Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project

Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project

1
Comments
3 min read
How to Delete Duplicate Data from a MySQL Database

How to Delete Duplicate Data from a MySQL Database

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

Common Table Expression (CTE) in PLSQL | Part 1

5
Comments
6 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
RANK,ROW_NUMBER and DENSE_RANK

RANK,ROW_NUMBER and DENSE_RANK

4
Comments 1
2 min read
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

24
Comments
7 min read
Insert data into tables - SQL

Insert data into tables - SQL

5
Comments
2 min read
Aggregate Functions vs Window Functions in SQL

Aggregate Functions vs Window Functions in SQL

5
Comments
2 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

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

4
Comments
8 min read
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!

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!

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

12
Comments 3
3 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
loading...