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

1 vote188 views1 answer
Ora-01950 no privileges on tablespace
SQL
34 votes175 views6 answers
Install mysql client ubuntu
SQL
1 vote102 views1 answer
Python escape string for sql
SQL
0 vote133 views1 answer
Database springboot
SQL
5 votes152 views3 answers
Oracle list columns in schema
SQL
0 vote151 views1 answer
Rename view mysql
SQL
7 votes146 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
1 vote136 views1 answer
Round function in sql oracle
SQL
0 vote160 views1 answer
Mysql enter ubuntu
SQL
0 vote152 views1 answer
Create bdd mysql
SQL