HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / vidyalakshmi.s
select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is truncate table?
How do you trace the traffic hitting a sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How do I create an extended event in sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Can group by be used without aggregate functions?
How will you make an attribute not process? : sql server analysis services, ssas
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What do you need to connect php to sql server?
If a stored procedure is taking a table data type, how it looks?
What is the use of set nocount on/off statement?
What is sql server profiler?
What is application role in sql server database security? : sql server security
What is store procedure? How do they work?