Answer Posted / vamsi

for example our emp table have duplicate rows than we can
run this query to delete those duplicate rows

Delete from emp a
where rowid <> ( select max(rowid) from emp where empno =
a.empno);

Is postgresql a server?

1005

---

What is string data type in sql?

1064

---

What is interval partition?

1001

---

What is the difference among union, minus and intersect?

955

---

What is t-sql? : Transact sql

936

---

What is the most common sql injection tool?

1001

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2076

---

what are rollup and cube in t-sql? : Transact sql

1052

---

what is heap table? : Sql dba

1054

---

What pl/sql package consists of?

1035

---

What is a dynamic query?

981

---

How do I debug a stored procedure?

1049

---

What is the cause of mutating table error and how can we solve it?

998

---

Is pl sql better than sql?

984

---

what happens if null values are involved in expressions? : Sql dba

1006

---