HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / gangi naidu.k
select * from emp where emp=(select sal from emp group by
sal having count(sal)>1)
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to start and end transact-sql statements?
Why it is recommended to avoid referencing a floating point column in the where clause?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is reportserver and reportservertempdb ?
Why we need sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the correct order of the logical query processing phases?
What are exact numeric data types in ms sql server?
What is it unwise to create wide clustered index keys?
What different steps will a sql server developer take to secure sql server?
Does partitioning improve performance?
Is it important for a database administrator to understand the operating system and file access?
How to optimize stored procedure optimization?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
what is a live lock? : Sql server database administration