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 is the difference between delete and truncate commands?
Which certification is best for sql?
What are field types?
What is before and after trigger?
What is a memo field?
What is data profiling in sql?
is mysql query is case sensitive? : Sql dba
What does the hierarchical profiler does?
Define the select into statement.
Can we create table inside stored procedure?
How many clustered indexes can be created on a table?
Explain the order of sql statement execution?
What is the purpose of the primary key?
What are the topics in pl sql?
Which type of cursor is used to execute the dml statement?