Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 68979 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
select Distinct * from dbo.EMP X
INNER JOIN dbo.EMP Y ON X.salary=Y.salary
AND X.ENAME<>Y.ENAME
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What are partitioned views?
What is 2nf example?
How will you optimize a stored procedure optimization?
What is difference between count (*) and count 1?
Give a example to search fr a string in all stored procedure in sql server.
your distribution database is full what will u do
What is difference between inner join and full join?
Difference between group by clause and having clause in SQL?
What is the difference between stored procedure and functions?
How to concatenate two binary strings together?
What are the properties of primary key?
What to check if a User database is locked?
Can we hide the definition of a stored procedure from a use?
What sql server means?
