Write a query to find the record, whose join_basic is maximum using employee table.
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways
Answer ( 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