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
What does normalization do to data?
What factors you will consider calculating the storage requirement for that view?
How to execute a stored procedure in ms sql server?
What method is used by the Command classes to execute SQL statements that return single values?
What is #table in sql server?
what is spatial nonclustered index
Which tools are available to manage SQL Azure databases and servers?
What is an identity column in insert statements?
What is a cursor, index in sql?
What is the difference between commit and rollback?
What is the data type of time?
What is update_statistics command?
What is the difference between implicit and explicit transaction?
How many joins in sql server?
What is 5nf in normalization form?