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

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.

in progress 0
Garima Singh 6 days 1 Answer 18 views Member 0

Answer ( 1 )

  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

Leave an answer

Browse
Browse