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

0 vote222 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote214 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote234 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote220 views1 answer
Sql check if column exists
SQL
1 vote240 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote227 views1 answer
Search mysql database for column
SQL
1 vote208 views3 answers
Epoch to datetime
SQL
1 vote212 views1 answer
Mysql pretty date format
SQL
0 vote245 views1 answer
Generate sql from specific migration ef core
SQL
0 vote229 views1 answer
Copying query result to excel
SQL