adspace


What is the difference between in and between in sql?

Answer Posted / Deepak Kumar Ravi

The `IN` keyword is used to check if a value matches any of the specified values within a list. The `BETWEEN` keyword is used to check a range of values. `BETWEEN` can be replaced with `>=` and `<=` for the same effect.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1101


What is the best sql course?

1064


How do I remove duplicates in two columns?

1202


What is the current version of postgresql?

1188


how to start mysql server? : Sql dba

1279


If a cursor is open, how can we find in a pl/sql block?

1252


Is primary key clustered index?

1028


what are the advantages of sql ? : Sql dba

1154


What is the current version of sql?

1106


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is collation? : Sql dba

1242


what is schema? : Sql dba

1163


what are aggregate and scalar functions? : Sql dba

1142


Can we rollback truncate?

1083


how to use regular expression in pattern match conditions? : Sql dba

1125