SQL BETWEEN Operator

The BETWEEN operator in SQL returns the values within the given range. The range can be text, number, or dates. The Between operators are inclusive which means the starting value and the ending values are included.

• Syntax of BETWEEN Operator –

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2;

Here, in the WHERE clause, we have added the between clause which has a range of values. The returned result will have the values that match the values in between value1 and value 2.

Demo Table – 

Product Table

Example – Consider the Product table of the Customer database where we want to get those customer names whose profit is between 100 to 1000.

SELECT DISTINCT Category,Region,City,Country,[Customer ID],[Customer Name],Sales FROM [dbo].[Products] WHERE Sales BETWEEN 100 AND 700;

The output after executing the above statement shows the customer’s names who have profits between 100 to 700 –

Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.

#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz