check whether all the emp numbers are indeed unique.
Answer Posted / biswajit rout
SELECT empno,count(*) FROM emp GROUP BY empno;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is Collation Sensitivity ? What are the various type ?
Can ddl statements be used in pl/sql?
What is a schema sql?
How many types of literals are available in pl sql?
What is query optimization in sql?
What are the different type of joins in sql?
What is rtm in testing?
What is trigger in pl sql?
Why do we use partitions in sql?
how many groups of data types? : Sql dba
Is left join inner or outer by default?
What is the use of function "module procedure" in pl/sql?
Does sql*plus also have a pl/sql engine?
What is the non-clustered index in sql?
How to select random rows from a table?