HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 46379 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
SELECT * FROM EMP WHERE (SAL IN (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))
| Is This Answer Correct ? | 54 Yes | 11 No |
Answer / vinay singh
Select * From Employee
Where Salary in
(Select Salary From Employee Group by Salary Having
Count(Salary ) > 1)
**Vinay Singh
**9867774724
| Is This Answer Correct ? | 31 Yes | 5 No |
Answer / aashish mangal
select A.id,A.salary from employee A inner join employee B
on A.salary = B.salary and A.id <> b.id
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / subbu
Query Output is :
SQL> select *from emp where sal=any( select sal from emp
group by sal having count(sal)>1);
EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- -------
--- ---------- ----------
7521 WARD SALESMAN 7698 22-FEB-81
1250 500 30
7654 MARTIN SALESMAN 7698 28-SEP-81
1250 1400 30
7788 SCOTT ANALYST 7566 19-APR-87
3000 20
7902 FORD ANALYST 7566 03-DEC-81
3000 20
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / raghuvir
Select *from Emp_table where salary=20000
will display all the employees who have salary 20000
| Is This Answer Correct ? | 30 Yes | 25 No |
Answer / dilip
SELECT * FROM EMP WHERE (SAL = (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))
| Is This Answer Correct ? | 28 Yes | 23 No |
Answer / vidyalakshmi.s
select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / antony
select distinct A.id,A.salary from employee A,employee B
where A.salary = B.salary and A.id <> b.id;
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / gangi naidu.k
select * from emp where emp=(select sal from emp group by
sal having count(sal)>1)
| Is This Answer Correct ? | 4 Yes | 1 No |
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
How to apply cascading referential integrity in place of triggers?
how to know description of a table in sqlserver 2000
Define master database?
Can you explain what is sql server english query?
How many types of the database links?
How to override dml statements with triggers?
What are the recovery models for a database?
How to retrieve field values using mssql_result()?
How to assign null values to variables or columns?
Do you know the cursor optimization tips?
-
Oracle (3238) - SQL Server (4518)
- MS Access (429)
- MySQL (1385)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3301)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
