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);

what is query cache in mysql? : Sql dba

766

---

What is rank function in sql?

724

---

describe transaction-safe table types in mysql : sql dba

701

---

What is varchar sql?

814

---

Is it possible to update views?

713

---

---

Why function is used in sql?

679

---

What is sql query limit?

699

---

What does the file extension accdb stand for?

707

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

728

---

what is bcp? When does it used? : Sql dba

706

---

How many types of indexes are there in sql?

719

---

what are myisam tables? : Sql dba

721

---

How to return an array from java to pl/sql?

788

---

Is a table valued function object?

759

---

What is a database? Explain

788

---