Sql subquery

Subquery in sql

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

Sql subquery

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

Source: learnsql.com

Subquery in sql

DELETE FROM dataflair_emp1
WHERE emp_id IN ( SELECT emp_id
                   FROM dataflair_emp2
                   WHERE age=25);  
select * from dataflair_emp1;

Similar codes

1 vote202 views1 answer
Ef core 5.0 usesqlserver not found
SQL
14 votes209 views5 answers
Set password for postgres user ubuntu
SQL
0 vote214 views1 answer
Search from comma separated values in sql server
SQL
1 vote226 views1 answer
Sql group by sum with condition
SQL
3 votes201 views1 answer
Sql insert inserted id
SQL
0 vote259 views2 answers
Sql unique
SQL
6 votes203 views1 answer
Sqlite foreign key
SQL
1 vote228 views1 answer
Mysql size int
SQL
0 vote193 views1 answer
Sql server bool select
SQL
0 vote227 views1 answer
T-SQL - Where Used List (Table/View)
SQL