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

2 votes178 views1 answer
SELECT INTO
SQL
1 vote248 views1 answer
Postgresql pass array in function
SQL
0 vote187 views1 answer
Update one column from another column in same table
SQL
0 vote201 views1 answer
Except in sql alchemy
SQL
0 vote189 views1 answer
Sqlite commands
SQL
0 vote173 views1 answer
Is numeric in sql
SQL
0 vote201 views1 answer
Function plsql
SQL
1 vote197 views1 answer
Select 2 rows in sql
SQL
0 vote219 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote189 views2 answers
Mysql to python pandas
SQL