check whether all the emp numbers are indeed unique.
- 6 Answers
- 15436 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
What is data types in sql?
What is the use of & in pl sql?
What is compute?
How do you concatenate in sql?
How can triggers be used for the table auditing?
What is function and procedure?
What is pragma in sql?
How do I start sql profiler?
Write a unique difference between a function and a stored procedure.
Explain the purpose of %type and %rowtype data types?
Which one is better sql or oracle?
What's the procedure?
what is the difference between primary key and unique key? : Sql dba
What is a crud api?
How many joins can you have in sql?
