How to use variable in SQL query?

MySQL, SQL Server, Oracle, PostgreSQL

How to use variable in SQL query?

In SQL, variables are used to store data that can be used and manipulated throughout a program. They are essential for dynamic SQL queries, where the values of the variables can be determined at runtime.

The syntax for declaring and using variables is different in different SQL databases.

Here are some examples:

MySQL variable in SQL query

In MySQL, you can declare a variable using the SET or SELECT statement.

Example of MySQL variable

SQL Server variable in SQL query

In SQL Server, you can declare a variable using the DECLARE statement and set its value using the SET statement.

SQL server leverage the DECLARE/SET statement rather than SET/SELECT


Oracle variable in SQL query

In Oracle, you can declare a variable in a PL/SQL block.

Oracle's leveraging a PL/SQL block.


PostgreSQL variable in SQL query

In PostgreSQL, you can use variables in functions, and the syntax is similar to Oracle's PL/SQL.

With PostgreSQL you can use functions

In all cases, once a variable is declared and assigned a value, it can be used in a query like this:

or

Remember to check the documentation of the SQL database you are using for the exact syntax and usage of variables.

New Release
Share

Get in Touch to Learn More

See Why Users Love CastorDoc

G2 leader badge spring 2023
G2 Users Love us badge
g2 leader badge winter 2023
Castor reviews sourced by G2

Fantastic tool for data discovery and documentation

“[I like] The easy to use interface and the speed of finding the relevant assets that you're looking for in your database. I also really enjoy the score given to each table, [which] lets you prioritize the results of your queries by how often certain data is used.”
Michal, Head of Data, Printify