How to include a single quote in a SQL query

INSERT SINGLE QUOTE IN SQL

---

This post explains how to insert a single quote in data/text/string.

It can be inserted by placing the single quotes in between a pair of single quotes.

This is compatible with all the databases like Snowflake, Teradata, Mysql, Postgresql, Oracle, PLSQL, Amazon Redshift.

Below is an example of how to include/ insert a single quote in SQL.

Insert a single quote in a SQL

---

Read More :

• What does count 1 mean in SQL?

---

• Difference between WHERE and HAVING clause

---

• Create a table from an existing table

---

• Snowflake NVL vs NVL2

---