Find all employees who are younger than employee whose id is 9999 : Select « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Select

Find all employees who are younger than employee whose id is 9999

    
SQL> create table emp
  2  ( empno      NUMBER(4)    constraint E_PK primary key
  3  , ename      VARCHAR2(8)
  4  , init       VARCHAR2(5)
  5  , job        VARCHAR2(8)
  6  , mgr        NUMBER(4)
  7  , bdate      DATE
  8  , sal        NUMBER(6,2)
  9  , comm       NUMBER(6,2)
 10  , deptno     NUMBER(2)    default 10
 11  ) ;

Table created.

SQL> insert into emp values(1,'Tom','N', 'Coder', 13,date '1965-12-17',  800 , NULL,  20);

1 row created.

SQL> insert into emp values(2,'Jack','JAM', 'Tester',6,date '1961-02-20',  1600, 300,   30);

1 row created.

SQL> insert into emp values(3,'Wil','TF','Tester',6,date '1962-02-22',  1250, 500,   30);

1 row created.

SQL> insert into emp values(4,'Jane','JM','Designer', 9,date '1967-04-02',  2975, NULL,  20);

1 row created.

SQL> insert into emp values(5,'Mary','P','Tester',6,date '1956-09-28',  1250, 1400,  30);

1 row created.

SQL> insert into emp values(6,'Black','R','Designer', 9,date '1963-11-01',  2850, NULL,  30);

1 row created.

SQL> insert into emp values(7,'Chris','AB','Designer', 9,date '1965-06-09',  2450, NULL,  10);

1 row created.

SQL>
SQL> select ename, init, bdate
  2  from   emp
  3  where  bdate > (select bdate
  4                  from   emp
  5                  where  empno = 99999);

no rows selected

SQL>
SQL>
SQL>
SQL> drop table emp;

Table dropped.








Related examples in the same category

1.The following code provides a breakdown of the basic SELECT statement on the Oracle platform:
2.Use Arithmetic operators with literal values to derive values: add 5 to salary
3.SELECT statement uses the not equal (< >) operator in the WHERE clause
4.Using the > operator
5.UPPER(SUBSTR(first_name, 2, 8)): Combining Functions
6.Plus in select statement
7.Minus in select
8.Math calculation in select
9.CONCATENATING TEXT
10.Returning All Columns
11.Returning Multiple Columns
12.Returning Rows Call
13.Employees from new york who have gifts
14.Selecting Categories That Contain Product
15.Selecting Products That Belong to Category
16.Selecting Products That Belong to Department with Join
17.Using select statement and char function to create insert statement