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 do you know about system database? : SQL Server Architecture
What is serializable?
Explain indexed views and partitioned view with their syntax.
What is efficiency data?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
what is datawarehouse?
Explain partitioned view?
What is the datatype of rowid?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to generate create table script on an existing table in ms sql server?
Explain having clause?
What are the different acid properties?
How does stuff differ from the replace function?
What is the library index called?
what does the automatic recovery do? : Sql server administration