what is the main difference between join and subqurey?
Answer Posted / 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 |
Post New Answer View All Answers
What are the operators used in select statements?
Differentiate between pl/sql and sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How to display the records between two range in Oracle SQL Plus?
Explain the order of sql statement execution?
What are the two different parts of the pl/sql packages?
What is sql rowcount?
how to select first 5 records from a table? : Sql dba
What is right join sql?
what are rollup and cube in t-sql? : Transact sql
Write a sql select query that only returns each name only once from a table?
What is the difference between microsoft access and sql server?
Is there a way to automate sql execution from the command-line, batch job or shell script?
differentiate between float and double. : Sql dba
how to include numeric values in sql statements? : Sql dba