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 varray in pl sql?

1120

---

Is oracel sql developer written in java?

1167

---

What are all the different types of indexes?

1195

---

What are the parts of a basic sql query?

1013

---

what is denormalization. : Sql dba

1160

---

Is crud a cuss word?

1073

---

How are sql commands classified?

1143

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4460

---

what is oltp (online transaction processing)? : Sql dba

1128

---

Is sql easier than java?

1069

---

What is the need of merge statement?

1092

---

What does pragma mean?

1130

---

What are procedures used for?

1036

---

Which is better trigger or stored procedure?

1014

---

Can we insert data into view?

948

---