Common Mistakes 01 - rownum and order by
SQL> create table hr . numbers (id number ) tablespace EXAMPLE ; Table created . SQL> insert into hr . numbers (id) values( 19 ); SQL> insert into hr . numbers (id) values( 3 ); SQL> insert into hr . numbers (id) values( 15 ); SQL> insert into hr . numbers (id) values( 9 ); SQL> insert into hr . numbers (id) values( 21 ); SQL> insert into hr . numbers (id) values( 7 ); SQL> insert into hr . numbers (id) values( 17 ); SQL> insert into hr . numbers (id) values( 1 ); SQL> insert into hr . numbers (id) values( 11 ); SQL> insert into hr . numbers (id) values( 5 ); SQL> commit; Commit complete. SQL> select id from hr . numbers ; ID ---------- 19 3 15 9 21 7 17 1 11 5 10 rows selected . Common Mistake. A common mistake is we