Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

Question

Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

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

Answer ( 1 )

  1. Garima Singh
    0
    Reply
    Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

    SQL> select employee.emp_no, emp_name, basic+DA-deduction as net_salary from employee,salary where employee.emp_no=salary.emp_no;
    SQL> select employee.emp_no, emp_name, basic+DA-deduction as net_salary,extract(month from salary_date) from employee,salary where employee.emp_no=salary.emp_no;


    Attachment

Leave an answer

Browse
Browse