HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 64767 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / dilip
SELECT * FROM EMP WHERE (SAL = (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))
| Is This Answer Correct ? | 28 Yes | 24 No |
Post New Answer View All Answers
What is data set in report?
Explain contrast amongst grouped and non-bunched records?
Can we join two tables without primary key?
What is the recursive stored procedure in sql server?
Explain the different types of backups available in sql server? : sql server database administration
What is the parse query button used for?
How you provide security to cube? : sql server analysis services, ssas
What is filtered index?
last function used in MS Access to convert sql what function will use in sql
Explain the database you used in your final year project?
What new data source types were added in ssrs 2014?
explain how to create a new schema in a database? : Sql server database administration
What is cte (common table expression)?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Can coalesce return null?
