About subquery ??

Question

please tell me if i use JOINS in sql query than their is no need na subquery and is their any difference JOIN and subqueries

Francis · Answer

which on is better sir No one is better. Since it hardly depends on the table's data on your hand. In some places join perform better way than sub-query. In some scenario vice versa. I would also like to highlight some comparisions about SQL Joins vs Subquery. http://sqlstudies.com/2013/05/02/comparing-an-inner-join-vs-a-subquery/ Hope this helps!

Jignesh Trivedi · Answer

Hi Yes its depending on your requirement which one tobe used. Join is giving better performance than sub query. hope this will help you.

Ranjit Powar · Answer

Its depends upon the requirements.

Chandu Kumawat · Answer

which on is better sir

Gantasala Venkatanarayanamurth · Answer

hello Joins and Subqueries are same in functionality but in joins there are different types and each type will work in different way but in subquery no more types so only one functionality. Hope you understand.

Jignesh Trivedi · Answer

Hi Subquery and JOINs both are different concept. yes most of the subquery can be replace by Joins but not all. hope this will help.