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

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

what is isam? : Sql dba

0 Answers  

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

What is set serveroutput on in pl sql?

0 Answers  

How insert into statements in sql?

0 Answers  

What is transaction control language (tcl)?

0 Answers  

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

Is pl sql better than sql?

0 Answers  

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

Cite the differences between execution of triggers and stored procedures?

0 Answers  

use of IN/ANY/ALL

5 Answers   Ramco,

For more SQL PLSQL Interview Questions Click Here
Categories