Breaking News: Grepper is joining You.com. Read the official announcement!

subquery sql

Add Answer

Innocent Iguana answered on December 26, 2020 Popularity 9/10 Helpfulness 3/10

answer subquery sql

related subquery in sql

related mssql subqueries

related SQL Subquery

related what is subquery in sql

related sub queries in sql

related why we use subquery in sql

related sql subquery

related subquery sql

related subquery in sql

subquery sql

Comment

-- Simple query with two tables
SELECT left_table.colx, right_table.coly
FROM left_table, right_table
WHERE left_table.common_col = right_table.common_col

-- Subquery inside FROM (turning a query into virtual table using alias, evolving from the previous query)
SELECT left_table.colx, right_table.coly
FROM left_table,
    (SELECT coly, colz, common_col          -- subquery start
    FROM another_table) AS right_table      -- subquery end
WHERE left_table.common_col = right_table.common_col
ORDER BY continent;


-- Subquery inside WHERE (You use it in Semi join / Anti Join)
SELECT left_table.*
FROM left_table
WHERE left_table.some_col <NOT> IN  -- Using "NOT" will result in Anti join
        (                           -- subquery start
            SELECT another_col      
            FROM right_table
        );                          -- subquery end

-- Subquery inside SELECT (REMEMBER: This query should only produce a single value)
SELECT
    outer_table.id,
    (SELECT COUNT(*) FROM inner_table WHERE outer_table.id = inner_table.id) AS new_col_1,              -- subquery 1
    (SELECT AVG(some_column) FROM inner_table WHERE outer_table.id = inner_table.id) AS new_col_2,      -- subquery 2
    (SELECT MAX(another_column) FROM inner_table WHERE outer_table.id = inner_table.id) AS new_col_3    -- subquery 3
FROM
    outer_table;

-- Using the WITH keyword (creating multiple virtual tables)
WITH
result_table1 AS (
    SELECT col1, col2 FROM t1),             -- subquery 1
result_table2 AS (
    SELECT colx, coly FROM t2)              -- subquery 2
SELECT * FROM result_table1, result_table2
WHERE result_table1.col1 <= result_table2.col2

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql subquery

Link to this answer
Share Copy Link

Contributed on Jan 28 2023

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

subquery in sql

Comment

SELECT column_name
 FROM table_name1
WHERE VALUE IN 
(SELECT column_name
FROM table_name2 
WHERE condition)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 19 2021

Innocent Ibis

0 Answers Avg Quality 2/10

mssql subqueries

Comment

USE AdventureWorks2016;
GO
SELECT Ord.SalesOrderID, Ord.OrderDate,
    (SELECT MAX(OrdDet.UnitPrice)
     FROM Sales.SalesOrderDetail AS OrdDet
     WHERE Ord.SalesOrderID = OrdDet.SalesOrderID) AS MaxUnitPrice
FROM Sales.SalesOrderHeader AS Ord;
GO

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

0 Answers Avg Quality 2/10

SQL Subquery

Comment

SELECT *
FROM Customers
WHERE age = (
  SELECT MIN(age)
  FROM Customers
);

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 22 2022

SAMER SAEID

0 Answers Avg Quality 2/10

what is subquery in sql

Comment

SUBQUERY IS NESTED QUERY INSIDE A SELECT, 
INSERT OR UPDATE METHODS. OR INSIDE ANOTHER SUBQUERY

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 20 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

sub queries in sql

Comment

-- Example 1: Using a subquery in the WHERE clause

SELECT column_name
FROM table_name
WHERE column_name IN (SELECT column_name FROM another_table);

-- Example 2: Using a subquery in the FROM clause

SELECT t1.column_name
FROM (SELECT column_name FROM table_name WHERE condition) AS t1
JOIN table_name2 AS t2 ON t1.column_name = t2.column_name;

-- Example 3: Using a subquery in the SELECT clause

SELECT column_name, (SELECT MAX(value) FROM another_table) AS max_value
FROM table_name;

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

why we use subquery in sql

Comment

We use subquery in order to get aggregate value in column without grouping data

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Apr 02 2021

Handsome Herring

0 Answers Avg Quality 2/10

sql subquery

Comment

SELECT name, listed_price
FROM paintings
WHERE listed_price > (
    SELECT AVG(listed_price)
    FROM paintings
);

Popularity 10/10 Helpfulness 2/10 Language sql

Source: learnsql.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 14 2022

Annoying IG

0 Answers Avg Quality 2/10

subquery sql

Comment

UPDATE Book SET note= 'editore: ' + (SELECT name FROM Publisher WHERE Publisher.ID = Book.publisher)

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.html.it

Tags: sql

Link to this answer
Share Copy Link

Contributed on Dec 26 2020

abdu

0 Answers Avg Quality 2/10

subquery in sql

Comment

UPDATE dataflair_emp1 
SET salary=35000
WHERE emp_id  = ( SELECT emp_id
                    FROM dataflair_emp1
                    WHERE post='Sr.Manager');     
select * from dataflair_emp1;

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 19 2021

Innocent Ibis

0 Answers Avg Quality 2/10

subquery sql

Contents

More Related Answers

subquery sql

Closely Related Answers

subquery in sql

mssql subqueries

SQL Subquery

what is subquery in sql

sub queries in sql

why we use subquery in sql

sql subquery

subquery sql

subquery in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.