{"id":26179,"date":"2018-08-24T08:37:32","date_gmt":"2018-08-24T08:37:32","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=26179"},"modified":"2021-03-12T14:50:50","modified_gmt":"2021-03-12T09:20:50","slug":"alias-operators-in-sql","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/alias-operators-in-sql\/","title":{"rendered":"Operators in SQL – Alias, IN and Between"},"content":{"rendered":"

In this tutorial, we will learn about the in and between clause of SQL and further we will discuss the need and use of aliases in SQL.<\/p>\n

Let us now dive deep into the In and Between clauses and the alias, we use in SQL with the examples.<\/p>\n

In and Between Clause in SQL<\/h3>\n

In SQL the clauses play an important role to simplify the queries. Similarly, the In clause is a shortcut tool for multiple Or conditions in a statement.<\/p>\n

In clause helps us to check multiple conditions in the where clause. It is compatible with almost all data types in SQL be it an int, string, date or numerics.<\/p>\n

The Between clause is put to select values in a given range (a,b) where a and b, both are inclusive.<\/p>\n

Like the In clause, Between clause is also compatible with almost all data types i.e. string, int, date etc.<\/p>\n

Below are the Syntax of both In and Between clause.<\/p>\n

Syntax of IN clause in SQL:<\/strong><\/p>\n

SELECT col1,col2,col3,.....\r\nFROM tableName\r\nWHERE col1 IN (val1, val2, ...);\r\n<\/pre>\n
OR<\/p>\n
SELECT col1,col2,col3,.....\r\nFROM tableName\r\nWHERE col1 IN (SELECT STATEMENT);\r\n<\/pre>\n
Syntax of BETWEEN clause in SQL:<\/strong><\/p>\n
SELECT  col1,col2,col3,.....\r\nFROM tableName\r\nWHERE col1 BETWEEN val1 AND val2;\r\n<\/pre>\n
What is Alias in SQL and Why do we need it?<\/h3>\n
An alias is a temporary reference name given to a table, column, or query result. The alias we create is temporary and exists only while the query is executing.<\/p>\n
Once the query is done executing, the alias also disappears.<\/p>\n
Some of the reasons why we need alias in SQL are as follows:<\/p>\n