Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Write a query to display all the employees who getting same salary in their departrment?

Jaytamil eniyanNov 16 2022

create table emp (emp_id NUMBER,name varchar2(30) , salary number , dep number );
begin
insert into emp values (100,'walker' , 3000 , 10 );
insert into emp values (101,'sam' , 10000 , 10 );
insert into emp values (102,'wick' , 7000 , 10 );
insert into emp values (103,'jhony' , 2000 , 20 );
insert into emp values (104,'deep' , 4000 , 20 );
insert into emp values (105,'shelby' , 2000 , 20 );
insert into emp values (106,'roger' , 8000 , 30 );
insert into emp values (107,'sky' , 8000 , 30 );
insert into emp values (108,'blake' , 8000 , 30 );
end;
/

Comments
Post Details
Added on Nov 16 2022
8 comments
2,382 views