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

3 votes107 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote111 views1 answer
Postgresql auto increment not working
SQL
2 votes93 views2 answers
Function in sql
SQL
0 vote116 views1 answer
Mysql grouping functions
SQL
3 votes99 views1 answer
Select without null values sql
SQL
1 vote111 views1 answer
Quit mysql
SQL
0 vote102 views1 answer
Mysql create table columns with spaces
SQL
1 vote115 views1 answer
How to group by month using sql server
SQL
3 votes106 views1 answer
Oracle transaction commit rollback example
SQL
3 votes102 views2 answers
Df to sql pandas sql achemy
SQL