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

Answer Posted / antony

select distinct A.id,A.salary from employee A,employee B
where A.salary = B.salary and A.id <> b.id;

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does normalization do to data?

518


What factors you will consider calculating the storage requirement for that view?

522


How to execute a stored procedure in ms sql server?

530


What method is used by the Command classes to execute SQL statements that return single values?

574


What is #table in sql server?

513






what is spatial nonclustered index

519


Which tools are available to manage SQL Azure databases and servers?

93


What is an identity column in insert statements?

561


What is a cursor, index in sql?

542


What is the difference between commit and rollback?

477


What is the data type of time?

493


What is update_statistics command?

553


What is the difference between implicit and explicit transaction?

543


How many joins in sql server?

489


What is 5nf in normalization form?

544