#between operator in sql

[krishna337]

SQL BETWEEN Operator

SQL BETWEEN operator checks if the value is within the range of values.The values can be numbers, text, or dates. It can be used in the SELECT, INCLUDE, UPDATE, or Delete statement. Syntax SELECT columnname(s) FROM tablename WHERE columnname BETWEEN value1 AND value2;   Example Consider the following table named…

View On WordPress

[krishna337]

SQL IN Operator

The SQL IN operator allows you to specify multiple values in WHERE Clause .it used to reduce the multiple condition OR in the SELECT, INSERT, UPDATE, or DELETE Statement. Syntax SELECT columnname(s) FROM tablename WHERE columnname IN (value1, value2, ...valueN);   Example Consider a table named “Students” and the table have some…

View On WordPress