2nd Example With WHERE Clause.

SQL> select * from emp where 1=1;

Explanation: 14 Rows are Selected and Displayed Because Condition 1=1 is True so all the rows are selected from emp table.

1st Example.

SQL> select * from emp;