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

7 votes157 views1 answer
Mysql unsafe update
SQL
5 votes172 views4 answers
Restart the psql server windows
SQL
0 vote132 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote143 views1 answer
Mysql server not running
SQL
0 vote155 views1 answer
Default password for mysql_secure_installation in mac
SQL
1 vote155 views1 answer
Insert value to new table by joining 2 different tables
SQL
2 votes185 views1 answer
How to create sql database
SQL
1 vote133 views1 answer
Mysql random limit 1
SQL
0 vote144 views2 answers
Timing sql queries
SQL
0 vote154 views1 answer
Postgresql import data from csv
SQL