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 Susaimichael · 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.

AI Agents Conference 2026

Top earners

Our Training Programs

AI & Machine Learning

Mastering Large Language Models

Mastering Prompt Engineering

Certified Vibe Coder

Github Copilot Training

Generative AI for Beginners

n8n Automation & AI Agents Training

About subquery ??

6 Replies