Answer / 14-07-2007

delete from emp where rowid not in(select min(rowid) from
emp group by empno;

Answer / smriti

delete from tablename a where a.rowid>(select min(rowid)
from tablename b where a.columnname=b.columnname)

Answer / srinivas ganamur

Delete from table t1
where t1.rowid>(select from table t2
from table t2
where t1.col_name=t2.col_name);

Srinivas Ganamur
Bangalore

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

Answer / amedela chandra sekhar

delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);

Answer / valli

delete from emp where rowid in(
select rowid from (
select emp_no, sal,rownum() over (emp_no,sal) as
Rownum from emp order_by emp_no,sal
) where rownum > 2
)

Can u create a primary key with out unique index.

8 Answers  

What do you mean by field in sql?

0 Answers  

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

How can we schedule the procedure to run automatically ?

3 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

How many types of keys are there in sql?

0 Answers  

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

What is pl sql script?

0 Answers  

what is the difference between nested subquery and correlated subquery?

0 Answers  

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

How to check if a column is nullable before setting to nullable?

0 Answers