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
- 1 Answers
- 3227 Views
- IAS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is prepared statement in sql?
How do I view output in sql developer?
Can we insert data in view?
Is not equal in sql?
what are the advantages of using stored procedures? : Sql dba
What is the most common sql injection tool?
What is the use of triggers?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What's the procedure?
What is trigger in flip flop?
what is 'mysqlshow'? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is sql keyword?
how to convert numeric values to character strings? : Sql dba
Explain what is table in a database?
