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 vote192 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote243 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote221 views1 answer
Sql anywhere create procedure
SQL
13 votes190 views5 answers
Sql default
SQL
0 vote211 views1 answer
How to add mysql to path on termin after installation
SQL
2 votes178 views1 answer
Possgress drop if exists table
SQL
0 vote357 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
3 votes178 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote180 views1 answer
Mysql select row with max value group by
SQL
0 vote177 views1 answer
Sql get number of days between two dates
SQL