Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / g.sathyanarayanan

Answers were Sorted based on User's Feedback



How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / akshita

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

Is This Answer Correct ?    11 Yes 3 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / mail2sentha

DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
EMP GROUP BY EMPID);

Is This Answer Correct ?    6 Yes 0 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / rohit kumar

Delete from employee where (empid,empname) notin (select min
(empid),empname from employee group by enmpname);

Is This Answer Correct ?    2 Yes 1 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / ajit

DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM < 2;

Is This Answer Correct ?    0 Yes 0 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / guest

u can delete by slelcting the rowid of that particular
record

Is This Answer Correct ?    3 Yes 4 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / his highness yadav

ur question is not much clear

is it to delete duplicate rows or

to delete all the rows which is repeating , and the original

fr the first the query above will work fine

second option try this

delete from emp a, emp b where a.empno=b.empno

i think this will go ,, this will delete the all records which
is duplicating


cheers

Is This Answer Correct ?    1 Yes 4 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / prajyot

Hi,

You can use the below mentioned query ....

SELECT ROWID( Emp_id ) FROM EMP WHERE Emp_id = 5;

Praj

Is This Answer Correct ?    1 Yes 5 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / vijay

Delete from emp where empid=5;

Is This Answer Correct ?    4 Yes 10 No

Post New Answer

More SQL PLSQL Interview Questions

What is secondary key?

0 Answers  

What is join view in sql?

0 Answers  

What is full form of rtm?

0 Answers  

how to start mysql server? : Sql dba

0 Answers  

What do you mean by “trigger” in sql?

0 Answers  

What are all types of user defined functions?

0 Answers  

How many primary keys can a table have?

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

What is the mutating table and constraining table?

0 Answers  

What are the different dml commands in sql?

0 Answers  

What is ROWID?

8 Answers  

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

For more SQL PLSQL Interview Questions Click Here
Categories