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
Explain trigger and its types?
What is sql server transaction log file?
How can windows applications connect to sql servers via odbc?
Do you know query execution plan?
What is field in algebra?
What are the types of subscriptions in SQL Server replication?
what is database replication? : Sql server database administration
What are the encryption mechanisms in sql server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is the osql utility?
How to truncate the log in sql server 2012? : sql server database administration
How can you insert null values in a column while inserting the data?
how will add additional conditions in sql?
How to change parameter value inside the report?
query processing