Use rownum in where clause to limit the row count : ROWNUM « Select Query « Oracle PL / SQL






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

   
    
  








Related examples in the same category

1.Use rownum in select clause
2.Use rownum in update set statement
3.Use rownum in where clause to control the row count
4.Use rownum column with order by
5.Limit the query to display only the top 3 highest paid employees.
6.Use rownum to limit the subquery
7.Use rownum = 1 and select into
8.Retrieving the Top Five Students with ROWNUM
9.Getting the Five Most Expensive Products