adspace


how to use in conditions? : Sql dba

Answer Posted / Vinod Kumar Bohra

In SQL, you can use the IN keyword for comparisons when the value is one of several possibilities. The syntax is `column_name IN (value1, value2, ...)`. To check if a value does not match any of the given values, you can use NOT IN.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of sql?

1094


what are aggregate and scalar functions? : Sql dba

1129


how to escape special characters in sql statements? : Sql dba

1114


Can we use distinct and group by together?

1133


Is primary key clustered index?

1019


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

1113


What is the current version of postgresql?

1178


how to start mysql server? : Sql dba

1267


what is schema? : Sql dba

1147


Is inner join faster than left join?

1277


what is bcp? When does it used? : Sql dba

1056


Does group by remove duplicates?

1112


Can delete statement be rollbacked?

1054


Is primary key always clustered index?

1095


what are all the common sql function? : Sql dba

1131