Write a query to find the record, whose join_basic is maximum using employee table.

Question

Write a query to find the record, whose join_basic is maximum using employee table.

in progress 0
Garima Singh 55 years 1 Answer 676 views Newbie 0

Answer ( 1 )

  1. SQL> select max(join_basic) from employee;

    MAX(JOIN_BASIC)
    —————
    50000

    SQL> select * from employee where join_basic=(select max(join_basic) from employee);

    EMP_NO EMP_NAME DESIGNATION JOIN_DATE JOIN_BASIC STATE
    ———- ————————————————– ————————————————– ——— ———- ———-
    102 Md. ALi Sr. Programmner 15-MAR-06 50000 MP


    Attachment

Leave an answer

Browse
Browse