what is the main difference between join and subqurey?
Answers were Sorted based on User's Feedback
Answer / ravi
all join may be sub query , but sub-query never be join
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ankush
A subquery is a query within a query.
A join is used to combine rows from multiple tables (2 or
more tables).
Its also can be done within a single table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / udayselva
Subquery returns only one row and Join return More than one rows
| Is This Answer Correct ? | 0 Yes | 6 No |
Can a procedure in a package be overloaded?
What is sql in java?
how to find 5th row ?
what is self join and why is it required? : Sql dba
Can I create table without primary key?
Which is faster union or join?
how to write utl file pkg in SQL
what is the command used to fetch first 5 characters of the string? : Sql dba
what are the disadvantages of mysql? : Sql dba
What is the limitation on the block size of pl/sql?
What are hotfixes and patches?
what is a join? : Sql dba
Oracle (3253)
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)