Answer Posted / eshwer

by using min(rowid) or max(rowid). its like deleting duplicate values.

select columns from emp where rowid not in[in] (select maxrow(id) from emp group by columns);

Can we create clustered index without primary key?

962

---

Can delete statement be rollbacked?

984

---

What is attribute indicator in pl sql?

1011

---

Is left join same as inner join?

1122

---

Can a select statement fire a trigger?

1154

---

what are all different types of collation sensitivity? : Sql dba

980

---

What is the use of desc in sql?

975

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1013

---

What is trigger types of trigger?

1067

---

What are the different ways to optimize a sql query?

946

---

Is sql sequential or random?

1029

---

What is trigger and stored procedure in sql?

1029

---

Define sql delete statement.

1009

---

How to add new employee details in an employee_details table with the following details

1089

---

What is the difference between execution of triggers and stored procedures?

1115

---