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

what is the main difference between join and subqurey?

Question Posted / udayselva

Answer Posted / udayselva

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is serial sql?

976

Is json a nosql?

981

Why do we use cursors?

990

How to convert comma separated string to array in pl/sql?

1184

What is trigger with example?

1101

Is it possible to create startup or shutdown trigger for on-schema?

1029

Define concurrency control. : Transact sql

1191

describe transaction-safe table types in mysql : sql dba

1006

Does sql full backup truncate logs?

1017

What is the difference between left join and right join?

946

What is cursor in pl sql with examples?

1034

Can we delete column in sql?

1100

what are the differences between char and varchar? : Sql dba

1071

Can you load data into multiple tables at once? : aql loader

1066

what is clause? : Sql dba

1063