Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 16333 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is pessimistic concurrency control? : Transact sql
What is flag in sql?
Can we rollback delete command?
Which sql statement is used to delete data from a database?
How many types of normalization are there?
how to use regular expression in pattern match conditions? : Sql dba
What are the different types of database management systems?
What are the string functions in sql?
what is the difference between char_length and length? : Sql dba
what is sql in mysql? : Sql dba
Does view contain data?
Name the operator which is used in the query for pattern matching?
How do you add a column to a table?
How insert into statements in sql?
what is query cache in mysql? : Sql dba
