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 |
Why are indexes and views important to an organization?
Can a trigger call a stored procedure?
Describe the Index, Types of index, At what situation we have used? Which one s better than others?
How do I tune a sql query?
What are properties of the transaction?
What is sap sql?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
What is an example of translating a date into julian format?
What is difference between joins and union?
What is sql comments?
What is graph sql?
diff b/w function and procedure?
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)