SQL Server Performance
  1. There is an 1)Emp tabel with (id,name,managerid,JoinDate,Salary,DeptNo)
    2)Dept tabel with(deptNo,DeptName,Loc)
    How to solve the following queries...
    a) Find all employee whose salary is greater than their manager
    b)In which year did most people join the company? Display the year and number of employees.
    c)Display the maximum salaries in each department. Along with the name of the department.
    Please send me solution of these queries
  2. FrankKalis Moderator

    Welcome to the forum!
    Don't you think you should your homework by yourself? [;)]
  3. Madhivanan Moderator

    What have you tried so far?

Share This Page