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 / ajit
DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM < 2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Are left and right joins the same?
How many tables can you join in sql?
What are the events on which a database trigger can be based?
What is a procedure in pl sql?
What are the disadvantages of not performing database normalization?
What are character functions?
Are sql database names case sensitive?
Can 2 queries be executed simultaneously in a distributed database system?
how to drop an existing index in mysql? : Sql dba
How can we link a sql database to an existing android app?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What are the different operators available in sql?
Is sql microsoft?
What is data control language (dcl)?
How is data stored on a disk?