What is the requirement of self-join?
No Answer is Posted For this Question
Be the First to Post Answer
what is a field in a database ? : Sql dba
What is the mutating table and constraining table?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is trigger explain with example?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
Explain uses of cursor.
What is self-join and what is the requirement of self-join?
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
Is left join inner or outer?
What is difference between pl and sql?
wht is the difference between sqlaserver2000 and 2005
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)