find the employee details who has the same salary as another employee from same department #sqltips

Description:
---Q : write an sql query to find the employee details who has the same salary
--as another employee from same department

create table employee(id int, name varchar(10),dept varchar(10),salary int);

insert into employee values(1,'Ram','Sales',100);
insert into employee values(2,'Syam','Sales',110);
insert into employee values(3,'Rohit','Sales',100);
insert into employee values(4,'Tom','IT',200);
insert into employee values(5,'Meena','IT',205);
insert into employee values(6,'Naveen','IT',200);
insert into employee values(7,'Srinu','Marketing',150);
insert into employee values(8,'Raju','Marketing',155);
insert into employee values(9,'yash','Marketing',160);

#sql
#sqllanguage
#sqltips
#sqlinterviewquestionsandanswers
#sqlinterviewquestions
#sqlforbeginners
#sqltraining