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
What are the different type of joins in sql?
Explain the purpose of %type and %rowtype data types?
What is the difference between python and sql?
What are triggers and its uses?
what is the difference between group by and order by in sql? : Sql dba
When to use inner join and left join?
What are the subsets of sql?
What are the disadvantages of file system?
What is a database event trigger?
Can a view be mutating? If yes, then how?
Do we need to create index on primary key?
How to convert comma separated string to array in pl/sql?
how to convert character strings to dates? : Sql dba
describe transaction-safe table types in mysql : sql dba
What are the basic techniques of indexing?