QUERY
Posted: Sat Jan 19, 2019 5:33 pm
Hello everyone,
I have a requirement described below.
I need to select deptno,maximum salary, minimum salary of each dept from emp table where dept contains atleast 2 employees and maximum salary in dept is > 50000.
I have attached the table data and query I have tried which is not giving any result , neither an error.
I have a requirement described below.
I need to select deptno,maximum salary, minimum salary of each dept from emp table where dept contains atleast 2 employees and maximum salary in dept is > 50000.
I have attached the table data and query I have tried which is not giving any result , neither an error.