check whether all the emp numbers are indeed unique.
Answer Posted / eswar
select empno,count(empno)
from emp group by empno having count(empno)>1;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many indexes can be created on a table in sql?
What are the types of operators available in sql?
What is parallel hint?
what is normalization? : Sql dba
What are different methods to trace the pl/sql code?
How do you define a foreign key?
How would you reference column values before and after you have inserted and deleted triggers?
Explain commit, rollback and savepoint.
What is Materialized View? In What Scenario we Use Materialized View?
How do I run sql profiler?
What is cold data?
Is json a nosql?
Do foreign keys improve performance?
Is sqlite thread safe?
How to return multiple rows from the stored procedure?