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 collation? : Sql dba

1242

---

what are all the common sql function? : Sql dba

1141

---

how to escape special characters in sql statements? : Sql dba

1124

---

Is inner join faster than left join?

1287

---

how to start mysql server? : Sql dba

1279

---

Can delete statement be rollbacked?

1065

---

What is the current version of postgresql?

1188

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

define sql insert statement ? : Sql dba

1110

---

what is schema? : Sql dba

1163

---

what are aggregate and scalar functions? : Sql dba

1142

---

Can we rollback truncate?

1083

---

Is primary key always clustered index?

1101

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

What is the current version of sql?

1106

---