Select Statement Examples

Example 1

Select *
  From users u
Where u.user_id > 50 ;

Example 2

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


Example 3

Select *
  From users u
Where u.user_id In (Select ul.user_id
                                    From users_log ul
                                  Where u.user_id = ul.user_id);