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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to delete duplicate rows from a join tables(I have three
tables on that join)
how do you know which join is need to be used?

The select statement I have is:

SELECT gc_skill_type.skill_type,
gc_area_tec.area,
gc_technology.technology,
gc_technology.id_technology,
gc_area_tec.id_area_tec
FROM gc_skill_type,
gc_area_tec,
gc_technology
WHERE gc_area_tec.id_skill_type (+) =
gc_skill_type.id_skill_type
AND gc_technology.id_area_tec (+) =
gc_area_tec.id_area_tec
order by gc_skill_type.skill_type asc, gc_area_tec.area asc,
gc_technology.technology asc

Question Posted / betasilva


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know ..

Answer / kumar

Seems to be an Inline View (Read Only). We cannot perform
dml operations on this query. Creating a complex with this
query may solve the issue.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between numeric and autonumber?

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

What are the types of optimization?

0 Answers  

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

What is user in sql?

0 Answers  

What are the built in functions of sql?

0 Answers  

What is difference between select statement and cursor

3 Answers   JDA,

how to delete an existing column in a table? : Sql dba

0 Answers  

What are the different ddl commands in sql?

0 Answers  

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

Is full outer join same as cross join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories