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 vote254 views1 answer
Oracle right characters
SQL
3 votes251 views2 answers
Having in mysql
SQL
0 vote269 views1 answer
Sql select merge multiple values
SQL
1 vote266 views1 answer
Select inside insert query
SQL
0 vote284 views1 answer
Name '_mysql' is not defined
SQL
0 vote304 views1 answer
Get role postgres
SQL
1 vote286 views3 answers
Union in sql
SQL
-1 vote284 views2 answers
Create temporary table sql
SQL
0 vote251 views1 answer
Wordpress sql find and replace
SQL
21 votes288 views3 answers
Sql server search column name in all tables
SQL