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 de-normalization and what are some of the examples of it?

1019

Is there any difference between the primary key and unique key?

1042

How to get a list of columns in a view using "sys.columns" in ms sql server?

1040

What does it mean if @@cursor_row returns a negative number?

1036

How raid can influence database performance?

1085

Give the query of getting last two records from the table in SQL SERVER?

1008

Explain Geometry datatype in sql server 2008 with example

1049

What to perform pattern match with the like operator?

933

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1030

Explain throw statement in sql server 2008?

1054

What will happen if a column containing char type data is changed to the nchar data type?

1151

Delete duplicate rows without using rowid.

1586

How do you manipulate data?

949

Explain the dirty pages?

1050

What is a non-clustered index?

1045