Explain the difference between 'between' & 'and' operators in sql



Explain the difference between 'between' & 'and' operators in sql..

Answer / Siddharth Kumar

The 'BETWEEN' operator is used to select records that fall within a specific range, and it includes the start and end values. For example: SELECT * FROM table WHERE column BETWEEN 1 AND 10.n The 'AND' operator is a logical operator used to combine multiple conditions in a WHERE clause. For example: SELECT * FROM table WHERE column1 = 'value1' AND column2 = 'value2'.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is TABLE SPACE?

4 Answers   ABB, TCS,


What is a parameter query?

1 Answers  


what are the drivers in mysql? : Sql dba

1 Answers  


What is trigger in sql? Explain

1 Answers  


what is the sql query to display current date? : Sql dba

1 Answers  


List different type of expressions with the example.

1 Answers  


What is partition in sql query?

1 Answers  


How packaged procedures and functions are called from the following?

2 Answers  


What is the purpose of a secondary key?

1 Answers  


What is vector point function?

1 Answers  


How much does sqlite cost?

1 Answers  


what are null values? : Sql dba

1 Answers  


Categories