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

what is the difference between undefined value and null value? : Sql dba

784


how to select unique records from a table? : Sql dba

825


How do I add a database to sql?

778


What are different methods to trace the pl/sql code?

741


what are the type of locks ? : Sql dba

720






What do you understand by case manipulation functions?

733


How do I view a view in sql?

697


what are the different index configurations a table can have? : Sql dba

750


What is primary and foreign key?

806


Determine if oracle date is on a weekend?

767


How to run sql*plus commands in sql developer?

802


What does varchar include?

683


how to do backup entire database? : Transact sql

884


What are commit, rollback, and savepoint?

738


When sql appeared?

815