what is self join and why is it required? : Sql dba
- 1 Answers
- 915 Views
- I also Faced
- E-Mail Answers
Answer / suresh pagadala
Self join is nothing but the table performs join condition itself same table is called self join
| Is This Answer Correct ? | 0 Yes | 0 No |
what is single byte over head in oracle..?
Explain two easy sql optimizations.
What are sql ddl commands?
why sql is used as interpreter frequently rather than a compile?
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
What is not null in sql?
What is the difference between sum and count in sql?
is it mandatory to select all the column in a view then what columns should be selected
What is integrity in sql?
check whether all the emp numbers are indeed unique.
How do I run a program in pl sql?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
