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 vote144 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
9 votes144 views6 answers
Sql add column with default value
SQL
1 vote163 views2 answers
Copy table in sql
SQL
1 vote164 views2 answers
Intersect sql
SQL
2 votes180 views6 answers
In operator in sql
SQL
2 votes156 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote150 views1 answer
Sql query tags
SQL
3 votes145 views2 answers
See mysql users ubuntu
SQL
0 vote132 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote141 views2 answers
How to know the character set of an oracle databes
SQL