check whether all the emp numbers are indeed unique.
- 6 Answers
- 16465 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
Does sql*plus have a pl/sql engine?
How to run pl sql program in mysql?
How do I count rows in sql query?
What are the query optimization techniques?
what is a unique key ? : Sql dba
Can dml statements be used in pl/sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is procedure in pl sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what is heap table? : Sql dba
What are the different types of constraints?
What is the difference between subquery and correlated query?
What is having clause in sql?
What is sql table?
Why stored procedure is faster than query?
