HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / aashish mangal
select A.id,A.salary from employee A inner join employee B
on A.salary = B.salary and A.id <> b.id
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is the difference between having clause and where clause in sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is a covered index?
What are the different types of indexes?
How do I start sql server agent automatically?
How to define the name and server for a new dsn?
What language is sql server written in?
What is indexing and its types?
What are translations and its use? : sql server analysis services, ssas
What are sql server procedures?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is the difference between functions and scalar functions?
What is difference between group by and having?
What is DCL?
What is the benefit of normalization?