Answer Posted / valli

select rowid from (
select emp_no, rownum() over (emp_no) as Rownum
from emp order_by emp_no,sal
) where rownum > 2

If this query returns no rows then we can say all the emp
numbers are indeed unique.

Regard,
Valli

What is the difference between a subquery and a join?

1012

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

984

---

What is a relationship and what are they?

1049

---

What are the differences between in and exists clause?

1048

---

What are the types of views in sql?

1039

---

How do you explain an index?

1222

---

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

991

---

What is pl sql architecture?

922

---

What are properties of the transaction?

957

---

What makes a good primary key?

980

---

What are some predefined exceptions in pl/sql?

1063

---

What are the events on which a database trigger can be based?

1101

---

What is record data type?

858

---

How to change sql*plus system settings?

995

---

what are the different type of sql's statements ? : Sql dba

872

---