what is self join and why is it required? : Sql dba
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 the difference between where clause and having clause? : Sql dba
What is window clause?
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
What is the difference between cross join and natural join?
In what condition is it good to disable a trigger?
Why stored procedures are faster than query?
in procedure how to return a value
What is trigger in pl sql with examples?
Can you rollback after commit?
What is using in sql?
What is a ddl command?
How do you optimize SQL queries ?
6 Answers CarrizalSoft Technologies, Infosys, Oracle,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)