Answer Posted / valli

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

What are the types of sql commands?

1162

---

what is meant by nl2br()? : Sql dba

1107

---

What is lexical units in pl sql?

1209

---

Does inner join return duplicate rows?

1039

---

i have some prob lem to tell me about my self in interview first round ...

2216

---

What is the maximum number of rows in sql table?

1081

---

what are the disadvantages of mysql? : Sql dba

1210

---

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

1046

---

Is there any restriction on the use of union in embedded sql?

1201

---

Explain the steps needed to create the scheduled job?

1092

---

Which is better join or inner query?

1128

---

what are numeric data types? : Sql dba

1111

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1127

---

Explain the significance of the & and && operators in pl sql.

1049

---

Explain what is a subquery ?

1245

---