Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Use rownum in where clause to limit the row count

SQL> SQL> CREATE TABLE departments   2  (department_id           number(10)            not null,   3   department_name      varchar2(50)      not null,   4   CONSTRAINT departments_pk PRIMARY KEY (department_id)   5  ); Table created. SQL> SQL> SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 1,             'Data Group' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 2,             'Purchasing' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 3,             'Call Center' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 4,             'Communication' ); 1 row created. SQL> SQL> SQL>  select department_name, upper( department_name )   2      from departments   3     where rownum < 2   4     order by department_name   5    / DEPARTMENT_NAME -------------------------------------------------- UPPER(DEPARTMENT_NAME) -------------------------------------------------- Data Group DATA GROUP 1 row selected. SQL> SQL> drop table departments; Table dropped. SQL> SQL> SQL> --