Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17607 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
Which version of sql do I have?
What are operators available in sql?
What is indexes?
What is the difference between functions, procedures, and packages in pl/sql?
Is it possible to read/write files to-and-from PL/SQL?
What do you understand by pl/sql packages?
What are secondary keys?
How do you remove duplicate records from a table?
What are the types of index in sql?
What are the two types of exceptions in pl/sql?
What is minus?
How do I sort a table in sql?
Can we alter stored procedure?
Why is there a need for sqlcode and sqlerrm variables?
How do you modify a column in sql?
