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 is the difference between delete and truncate commands?

1039


Which certification is best for sql?

986


What are field types?

1004


What is before and after trigger?

959


What is a memo field?

969


What is data profiling in sql?

1077


is mysql query is case sensitive? : Sql dba

1101


What does the hierarchical profiler does?

1058


Define the select into statement.

1056


Can we create table inside stored procedure?

955


How many clustered indexes can be created on a table?

1075


Explain the order of sql statement execution?

1045


What is the purpose of the primary key?

1063


What are the topics in pl sql?

970


Which type of cursor is used to execute the dml statement?

957