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
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain the different types of joins?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is filtered index?
What is self join in sql server joins?
What do you understand by check constraint in sql server?
What is autocommit mode in sql server?
Where is my database stored on the hard disk in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is system stored procedures?
Why it is recommended to avoid referencing a floating point column in the where clause?
What is the difference between functions and scalar functions?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is coalesce and check constraint in sql server?
What is the difference between composite index and covering index?