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.

What is file based approach?

999

---

How do I view a procedure in sql?

1019

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2555

---

What is snowflake sql?

1128

---

how to get @@error and @@rowcount at the same time? : Sql dba

1082

---

how can we know the number of days between two given dates using mysql? : Sql dba

1087

---

what is sql? : Sql dba

1071

---

write an sql query to find names of employee start with 'a'? : Sql dba

1089

---

What is transaction control language (tcl)?

1186

---

What are the key differences between SQL and PL SQL?

1286

---

What are synonyms in sql?

1019

---

How to check if a column is nullable before setting to nullable?

1185

---

What is sql table?

1022

---

what is the difference between a web-garden and a web-farm? : Sql dba

1144

---

what is “go” in t-sql? : Transact sql

1158

---