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

23 votes251 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote337 views2 answers
Begin transaction sql
SQL
1 vote282 views1 answer
Postgres set sequence value to max id
SQL
0 vote270 views1 answer
Oracle shrink table
SQL
0 vote282 views1 answer
Tsql delete all rows
SQL
1 vote307 views1 answer
Delete mysql ubuntu 20.04
SQL
3 votes257 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote208 views1 answer
How to get last client id sql
SQL
0 vote252 views1 answer
Drop all data from tables
SQL
0 vote262 views1 answer
Désinstaller postgresql linux
SQL