what is the main difference between join and subqurey?

Answer Posted / udayselva

Subquery returns only one row and Join return More than one rows

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

597


Does truncate free space?

517


Why is a primary key important?

546


Is grant a ddl statement?

453


What is pl/sql table? Why is it used?

560






Do stored procedures prevent sql injection?

549


Enlist the characteristics of pl/sql?

1240


How do I partition in sql?

537


How many commands are there in sql?

547


How to install oracle sql developer?

566


what is a view? : Sql dba

636


What is keys and its types?

541


Where not exists in sql?

503


What are pl/sql cursor exceptions?

571


What can sql server reporting services do?

581