Oracle Tutorial

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);