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

What is difference between index and primary key?

1059

Is there any difference between primary key and unique with the not null condition?

913

What is spatial and temporal data?

944

Please differentiate between a local and a global temporary table?

964

what are different types of raid configurations? : Sql server database administration

1008

How is a full-text index updated?

912

What is sql server 2000 work load governor?

1001

What is a cache in ssrs?

132

What is SQL Azure Fabric?

110

How many levels of sp nesting are possible?

974

Why should one not prefix user stored procedures with ‘sp_’?

1004

What is ms sql server reporting services?

1013

What are the tables in sql?

1057

What is Command line parameters in PLSQL.?

1078

Do you know clustered and non-clustered index?

950