SQL List

Daniele Quero, PhD

Oct 26, 2022

--

The “Query of Queries” Trick to Auto-Produce SQL Statements

A super-effective SQL Injection trick

medium.com

SQL NOT IN and LEFT JOIN Alternatives to Filter Query-Results

It’s good to have a choice

medium.com

SQL Injection

Is Code Injection GOOD or BAD?

medium.com

Oracle SQL: How to get the First and Last Day of a Month

Simple and Parametric Examples, plus a juicy one.

medium.com

Daniele Quero, PhD

Written by Daniele Quero, PhD

A professional developer with passion for game developing and skill-growing. A former Nuclear Physics Researcher who changed his life to pursue his dreams

Recommended from Medium

T-SQL three-valued logic and ANSI_NULLS setting!

Sergio Govoni
in
CodeX

T-SQL three-valued logic and ANSI_NULLS setting!

Possible values of the logical evaluation of an expression

3 min readJul 10

--

Mastering SQL Aggregation Functions: A Comprehensive Guide with Examples

SQL Fundamentals
in
DevOps.dev

Mastering SQL Aggregation Functions: A Comprehensive Guide with Examples

Aggregation functions play an important role in SQL when it comes to summarizing and analyzing data. They allow us to calculate statistical…

5 min readSep 2

--

Lists

New_Reading_List

174 stories209 saves

ChatGPT

22 stories291 saves

Natural Language Processing

924 stories440 saves

Data Transformation with SQL

Mr. Data Master

Data Transformation with SQL

Hello Folks🙂,

2 min readNov 1

--

Oracle SQL With Function clause

Martien van den Akker
in
Nerd For Tech

Oracle SQL With Function clause

It’s been around for a while: the with-clause in Oracle SQL. And indeed, I used it in the past. The with clause is very useful to…

3 min readJun 15

--

Mastering SQL Sub-queries : Learn by doing

Nelson M.
in
Javarevisited

Mastering SQL Sub-queries : Learn by doing

6 min readNov 16

--

Understanding SQL Types of Indexes: A Beginner’s Guide

JackyNote ⭐️

Understanding SQL Types of Indexes: A Beginner’s Guide

Learn essential SQL index types: single-column, composite, unique, full-text, and bitmap indexes for efficient database queries

4 min readOct 2

--

See more recommendations

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams