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 vote225 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote231 views1 answer
Search starting with mysql
SQL
2 votes244 views1 answer
Show max_allowed_packet mysql
SQL
1 vote228 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote226 views1 answer
Full sql mode
SQL
4 votes227 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote230 views1 answer
Delete * from where id = 1;
SQL
5 votes228 views1 answer
Oracle ORA-00054 origin
SQL
-1 vote232 views2 answers
First letter capital in mysql query
SQL
11 votes228 views1 answer
Ddl materialized view
SQL