how to use in conditions? : Sql dba



how to use in conditions? : Sql dba..

Answer / 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

More SQL PLSQL Interview Questions

How can you get sql*loader to commit only at the end of the load file? : aql loader

1 Answers  


Explain the insert into statements in sql?

1 Answers  


With out using count() function. How to the find total number of rows in a table?

6 Answers  


How show all rows in sql?

1 Answers  


How to return multiple records from procedure?

2 Answers  


tell us something about heap tables. : Sql dba

1 Answers  


What is schema in sql example?

1 Answers  


I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  


What is a pdo connection?

1 Answers  


What are the different schemas objects that can be created using pl/sql?

1 Answers  


consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,


What is a schema sql?

1 Answers  


Categories