Simple demo for IN : In « Select Clause « SQL / MySQL

Home
SQL / MySQL
1.Aggregate Functions
2.Backup Load
3.Command MySQL
4.Cursor
5.Data Type
6.Database
7.Date Time
8.Engine
9.Event
10.Flow Control
11.FullText Search
12.Function
13.Geometric
14.I18N
15.Insert Delete Update
16.Join
17.Key
18.Math
19.Procedure Function
20.Regular Expression
21.Select Clause
22.String
23.Table Index
24.Transaction
25.Trigger
26.User Permission
27.View
28.Where Clause
29.XML
PostgreSQL
MySQL Tutorial
SQL / MySQL » Select Clause » In 
Simple demo for IN
  
/*
mysql> Drop table report;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE report (
    ->        article INT(4),
    ->        dealer  CHAR(20),
    ->        price   DOUBLE(16,2)
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO report VALUES (1,'A',4.45),
    ->                         (1,'B',5.45),
    ->                         (2,'A',16.67),
    ->                         (3,'B',6.12),
    ->                         (3,'C',2.78),
    ->                         (3,'D',2.34),
    ->                         (4,'D',21.29);
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM report;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|       1 | A      |  4.45 |
|       1 | B      |  5.45 |
|       2 | A      | 16.67 |
|       3 | B      |  6.12 |
|       3 | C      |  2.78 |
|       3 | D      |  2.34 |
|       4 | D      | 21.29 |
+---------+--------+-------+
7 rows in set (0.01 sec)

mysql> SELECT *
    -> FROM report
    -> WHERE dealer IN("A","C","D");
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|       1 | A      |  4.45 |
|       2 | A      | 16.67 |
|       3 | C      |  2.78 |
|       3 | D      |  2.34 |
|       4 | D      | 21.29 |
+---------+--------+-------+
5 rows in set (0.00 sec)


*/

Drop table report;  

CREATE TABLE report (
       article INT(4),
       dealer  CHAR(20),
       price   DOUBLE(16,2)
);

INSERT INTO report VALUES (1,'A',4.45),
                        (1,'B',5.45),
                        (2,'A',16.67),
                        (3,'B',6.12),
                        (3,'C',2.78),
                        (3,'D',2.34),
                        (4,'D',21.29);
    
SELECT * FROM report;    

  
SELECT *
FROM report
WHERE dealer IN("A","C","D");

           
         
    
  
Related examples in the same category
1.Use IN for static values
2.Use IN and order rows
3.Simple demo for NOT IN
4.Use IN for string value
5.Use IN and BETWEEN AND
6.Use IN in where clause
7.Find the match numbers and the number of sets won and lost of all matches that were won 3-1 or 3-2.
8.In operator and char type
9.SELECT statement uses the NOT IN operator
10.Constant value with in opertator
11.Comparisons with a large number of values can be carried out easily with IN:
12.Sub query with IN command
13.Sub query with NOT IN command
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.