Where Examples

Example 1

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

Example 2

Select *
  From books b
Where b.author = 'SMITH'
    And book_name Like '%ORACLE%'


Example 3

Select id, name, create_date
  From users
Where create_date > (Select create_date
                                         From users
                                       Where name='SCOTT' )