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 autocommit sql?

538


What are the datatypes available in pl/sql ?

607


How many types of cursors are available in pl/sql?

582


Can we use update in sql function?

576


What are the possible values that can be stored in a boolean data field?

513






What does varchar include?

517


How do sql triggers work?

550


What is dense_rank in sql?

539


what is 'mysqlshow'? : Sql dba

582


What is sql select statement?

503


Are left and right joins the same?

529


What is sql data?

546


how many sql ddl commands are supported by 'mysql'? : Sql dba

521


What is the difference between count 1 and count (*) in a sql query?

495


How do I truncate a sql log file?

529