Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17450 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 are tables and fields? : Sql dba
What are the types pl/sql code blocks?
What is sql character function?
What are %type and %rowtype for?
How to run sql statements with oracle sql developer?
What is a left join?
how to use myisamchk to check or repair myisam tables? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
Is primary key an index?
What is the use of sqldataadapter?
what are the differences between char and nchar? : Sql dba
How many subqueries can be nested in a statement?
Which nosql database is best?
how to shut down the server with 'mysqladmin'? : Sql dba
What is program debugging?
