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
Why use stored procedures in sql server?
Can truncate be rolled back?
What are clustered and non-clustered index?
How many primary keys are possible in a table?
How to loop through returning rows?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How network traffic be reduced by using the stored procedure?
What are the properties of the transaction?
Explain for xml explicit mode?
What is indexed view?
How many types of stored procedures are there in sql server?
Does windows server 2016 come with sql server?
How to how to convert numeric expression data types using the convert() function??
What is partition, how will you implement it? : sql server analysis services, ssas
What is implicit cursors?