Write a query using above tables to find the employee no, name, designation, whose net salary(basic+DA-Deduction) is minimum in the month of June 2011.
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 employee.emp_no, emp_name, designation from employee, salary where basic+da-deduction=(select min(basic+da-deduction) from salary where salary_date=’30-jun-2011′);
EMP_NO EMP_NAME DESIGNATION
———- ————————————————– ————————————————–
101 Ramesh Kumar Asst. Programmner
102 Md. ALi Sr. Programmner
103 Michel Programmner
104 Amit Kumar System Analyst
105 Arshad Ali Network Administrator
106 Deepak Kumar Programmer
6 rows selected.
Attachment