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
- 16566 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
How many unique keys can a table have?
What is procedure explain with program?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is nvarchar max in sql?
Is primary key always clustered index?
Can a table contain multiple primary key’s?
How many clustered indexes can be created on a table?
What is the maximum rows in csv?
What are pl sql procedures?
What is difference between table and view?
What is attribute indicator in pl sql?
How do I count duplicates in sql?
What are the events on which a database trigger can be based?
What are the different sql commands?
How many sql core licenses do I need?
