Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / vijay

Delete from emp where empid=5;

Is This Answer Correct ?    4 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different type of joins in sql?

905


Explain the purpose of %type and %rowtype data types?

875


What is the difference between python and sql?

937


What are triggers and its uses?

1001


what is the difference between group by and order by in sql? : Sql dba

1051


When to use inner join and left join?

903


What are the subsets of sql?

1036


What are the disadvantages of file system?

1162


What is a database event trigger?

1079


Can a view be mutating? If yes, then how?

959


Do we need to create index on primary key?

851


How to convert comma separated string to array in pl/sql?

1110


how to convert character strings to dates? : Sql dba

982


describe transaction-safe table types in mysql : sql dba

943


What are the basic techniques of indexing?

1012