How to use SQL in statements

How to use SQL in statements

In
In allows you to specify multiple values In the WHERE clause.

SQL syntax

SELECT column_name(s)FROM table_nameWHERE column_name IN (value1,value2,...)

Let's take a look at an instance. below is the data

 
 

  
  
 
   
 
    
_Id
 
    
LastName
 
    
FirstName
 
    
Address
 
    
City
 
   
 
   
 
    
1
 
    
Hansen
 
    
Ola
 
    
Timoteivn 10
 
    
Sandnes
 
   
 
   
 
    
2
 
    
Svendson
 
    
Tove
 
    
Borgvn 23
 
    
Sandnes
 
   
 
   
 
    
3
 
    
Pettersen
 
    
Kari
 
    
Storgt 20
 
    
Stavanger
 
   
 
  
 
 

Now, we want to select the person with the surname "Hansen" or "Peterson" from the above table.

We use the following SELECT statement:
 
SELECT * FROM PersonsWHERE LastName IN ('Hansen','Pettersen')
 
Output result
 
  
  

   
   
 
    
 
     
_Id
 
     
LastName
 
     
FirstName
 
     
Address
 
     
City
 
    
 
    
 
     
1
 
     
Hansen
 
     
Ola
 
     
Timoteivn 10
 
     
Sandnes
 
    
 
    
 
     
3
 
     
Pettersen
 
     
Kari
 
     
Storgt 20
 
     
Stavanger
 
    
 
   
  
  
 
Note: For reprint, please indicate that it is from www.111cn.cn/database/database.html