Answer Posted / ch. nageswar subudhi

For delete the DUPLICATE RECORD from Table by using this
Query:

DELETE FROM EMP E
WHERE E.ROWID <>(SELECT MIN(ROWID) FROM EMP E2 WHERE
E.EMP_NO=E2.EMPNO);

Can we have two clustered index on a table?

762

---

How many commands are in sql?

716

---

What are sql*plus environment variables?

772

---

What is compound trigger?

754

---

How many subqueries can be nested in a statement?

693

---

---

When sql appeared?

815

---

Explain some predefined exceptions.

778

---

Why do we need databases?

730

---

Can we use pl sql in sql server?

739

---

Explain unique key in sql.

738

---

What problem one might face while writing log information to a data-base table in pl/sql?

761

---

how do you know the version of your mysql server? : Sql dba

690

---

What is hibernate and its relation to sql?

789

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6595

---

What is numeric function sql?

724

---