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 query cache in mysql? : Sql dba

0 Answers  

What is cursor status?

0 Answers  

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

diff b/w sub query and co-relater query?

3 Answers   iFlex,

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

What is number function in sql?

0 Answers  

What is dml and ddl?

0 Answers  

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories