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


Please Help Members By Posting Answers For Below Questions

What are functions in the sql server?

608


Explain the first normal form(1nf)?

563


in the physical file layout, where should the transaction log be stored in relation to the data file?

537


What is page-level compression?

558


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

548






What is a database in ms sql server?

554


what are the different types of SSRS reports?

112


What is local temp table?

558


What languages bi uses to achieve the goal?

514


How much memory that we are using in Logshipping Concept?

1370


whats the maximum size of view state??

1726


How to enable tcp/ip protocol on a sql server?

591


Explain the difference between clustered and non-clustered index?

546


Explain raiserror in sql server?

578


How to generate create table script on an existing table in ms sql server?

645