SQL query on emp table to display the employee name, his salary, sum of his department salary

Replies

• 

  [Prototype]

  Considering you're using MySQL,
  
  

  SELECT * FROM `emp`

  Are you trying to query from php and wants to display the results on the webpage?
• 

  Neeraj Sharma

  [Prototype]

  Considering you're using MySQL,
  
  

  SELECT * FROM `emp`

  Are you trying to query from php and wants to display the results on the webpage?

  I am doing it on sqldeveloper. And I am not a noob that I dont know the query that you have given me. Please read my question again and then answer
• 

  Prashanth_p@cchi

  select empname sal sum(sal) from emp group by deptno;
  select sal from emp e where sal <
  (select max(sal) from emp ea where ea.deptno = e.deptno) order by sal;
  
  I am not sure of the above. It has been more that two years, me writing a SQL Query. Hope it might help you in arriving at the solution.
• 

  Anoop Kumar

  select e.emp_name, e.Emp_sal,
  (select sum(e1.emp_sal) from emp_tab e1
  where e.dept_id=e1.Dept_id  group by e.Dept_id) as Salary_Sum,
  (Select emp_sal from emp_tab e2 where rownum=2 and
  e2.dept_id=e.dept_it order by e2.emp_salary  desc ) as Sec_High_salary
  from emp_tab e where e.emp_ID='XXXXX'

• 

  Prashanth_p@cchi

  ianoop

  select e.emp_name, e.Emp_sal,
  (select sum(e1.emp_sal) from emp_tab e1
  where e.dept_id=e1.Dept_id  group by e.Dept_id) as Salary_Sum,
  (Select emp_sal from emp_tab e2 where rownum=2 and
  e2.dept_id=e.dept_it order by e2.emp_salary  desc ) as Sec_High_salary
  from emp_tab e where e.emp_ID='XXXXX'

  I think this should work... Nice!