In « Select Clause « SQL / MySQL






  1. SQL / MySQL
  2. Select Clause
  3. In
1.Use IN for static values
2.Simple demo for IN
3.Use IN and order rows
4.Simple demo for NOT IN
5.Use IN for string value
6.Use IN and BETWEEN AND
7.Use IN in where clause
8.Find the match numbers and the number of sets won and lost of all matches that were won 3-1 or 3-2.
9.In operator and char type




10.SELECT statement uses the NOT IN operator
11.Constant value with in opertator
12.Comparisons with a large number of values can be carried out easily with IN:
13.Sub query with IN command
14.Sub query with NOT IN command