HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / vinay singh
Select * From Employee
Where Salary in
(Select Salary From Employee Group by Salary Having
Count(Salary ) > 1)
**Vinay Singh
**9867774724
Is This Answer Correct ? | 45 Yes | 5 No |
Post New Answer View All Answers
What are the limitations in ssrs on sql server express edition?
How do I find sql server instance name?
Can sql servers linked to other servers?
What are the steps you can take to avoid “deadlocks”?
How do I setup a local sql server database?
What is a full text index?
What are the two modes of authentication in sql server?
What is forward - only cursors / read only cursor?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Can you tell me some of the common replication dmv's and their use? : sql server replication
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is bookmark link in ssrs?
Which are the important points to note when multilanguage data is stored in a table?
What is the difference between insensitive and scroll cursor?
Give an example of why you would want to denormalize a database