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

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2205

---

What is row_number () in sql?

1023

---

How many types of index are there?

1099

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1016

---

What is the left table in sql?

1014

---

What is the starting oracle error number?

1096

---

Where not exists in sql?

1032

---

What is embedded sql what are its advantages?

1108

---

How to display the current date in sql?

1129

---

What are the three forms of normalization?

1092

---

What is raw datatype in sql?

1103

---

What is use of term?

1126

---

give the syntax of grant and revoke commands? : Sql dba

1216

---

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

1028

---