select e1.First_name,e1.salary from emp e1,emp e2 where e1.ROWID <>

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Question Posted / harish

Answer Posted / harish

select e1.First_name,e1.salary from emp e1,emp e2 where
e1.ROWID <> e2.ROWID and e1.salary=e2.salary;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When we should use @@error?

970

How to define and use table alias names in ms sql server?

1135

Explain iaas, paas and saas?

Explain different forms of normalization?

948

What stored by the model?

1060

What are advantages of ssrs or why we should use ssrs?

139

What are sql server functions?

987

What do you mean by a Composite primary key?

1104

What are the joins in sql server? : sql server database administration

1010

What is the difference between clustered and non-clustered indexes in ms sql server?

1003

What is global temp table?

997

What is 2nf normalization form?

1139

What is delete query?

941

What is normalization? Explain its different types?

1093

How can I get data from a database on another server?

997