Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17699 Views
- I also Faced
- E-Mail Answers
Answer Posted / santhi kandasamy
In Oracle,
select empno from emp where empno is not null
group by empno
having count(*) >1;
if the above query does not return any rows then you can
consider, empno having unique values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How can you view the errors encountered in a trigger?
Are stored procedures faster than queries?
Does google use sql?
Where is sql database stored?
What are the rules to be applied to nulls whilst doing comparisons?
What is difference between hql and sql?
what are the disadvantages of mysql? : Sql dba
What are the types of optimization?
What is pl sql in oracle?
What is the purpose of primary key?
What is an alias command?
What are the different sql commands?
Define join and name different types of joins?
what is text? : Sql dba
What is rank dense_rank and partition in sql?
