Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17682 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 to write html code in pl sql?
What is prepared statement in sql?
What are sql functions? Describe the different types of sql functions?
What is a unique key and primary key and foreign key?
What is difference between left and right outer join?
What is schema in sql example?
How is use pl and sql?
Can we rollback after truncate?
What is the advantage of nosql?
Can we use views in stored procedure?
What is execution plan in sql?
What is dense_rank?
What are the benefits of pl/sql packages?
What are the query optimization techniques?
What is foreign key and example?
