OR Examples

Example 1

Select *
  From users u
Where u.name = 'ANIA'
     OR u.name = 'PARKER' ;

Example 2

Select *
  From tutorials
Where author = 'TOM'
      OR title Like '%ORACLE%'


Example 3

Select *
  From books
Where price >= 1000 OR price >= 700 ;

Example 4

Select *
  From cities
Where country_id >= 10 OR city_name Like '_M' ;