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

Why do we use partitions in sql?

1057

---

What is a pl/sql block?

1237

---

tell me about various levels of constraint. : Sql dba

1041

---

what is an extent ? : Sql dba

1109

---

What is mdf ldf and ndf?

1007

---

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

1037

---

how are mysql timestamps seen to a user? : Sql dba

1147

---

Is it possible to update views?

970

---

how can you see all indexes defined for a table? : Sql dba

1006

---

Explain ddl statements in pl/sql?

1014

---

Explian rowid, rownum? What are the psoducolumns we have?

1008

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

961

---

Mention what does plv msg allows you to do?

1131

---

Explain the structure of pl/sql in brief.

1099

---

What is a temporal table?

936

---