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.

Explain what is dbms?

1039

---

What are pl/sql cursor exceptions?

1077

---

What are some emotional triggers?

964

---

What is the use of <> sql?

961

---

Does group by remove duplicates?

1021

---

Can you join a table to itself?

1108

---

What is a schema? How is it useful in sql servers?

1096

---

Define commit, rollback and savepoint?

1016

---

what are the different tables present in mysql? : Sql dba

958

---

How much does sql cost?

974

---

what is the difference between a having clause and a where clause? : Sql dba

1062

---

how can we find the number of rows in a table using mysql? : Sql dba

1069

---

How do I remove all records from a table?

1062

---

What are different types of statements supported by sql?

1147

---

Is join and inner join the same?

990

---