How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id

Answer Posted / vijay

Delete from emp where empid=5;

Is This Answer Correct ?    4 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql function call stored procedure?

566


What is nvarchar in sql?

535


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2015


What are the sql commands?

619


If a cursor is open, how can we find in a pl/sql block?

690






What is multiple partition?

547


How to fix oracle error ora-00942: table or view does not exist

577


What is pl sql in oracle?

596


How do I delete a trigger?

549


What is substitution variable?

591


Is sql a dbms?

542


What is sql clause?

552


What does desc stand for?

602


Differentiate between pl/sql and sql?

627


How can I delete duplicate rows?

573