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 vote195 views1 answer
How to fetch unique records from two tables
SQL
0 vote183 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote207 views2 answers
How covert into int in maria db
SQL
5 votes202 views1 answer
Invalid column name sql
SQL
0 vote147 views1 answer
Finish transaction sql
SQL
1 vote207 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote186 views1 answer
List index mysql cli
SQL
7 votes195 views6 answers
Group_concat mysql
SQL
3 votes204 views2 answers
Mysql import gz
SQL
0 vote208 views1 answer
Edit shchima table in sql
SQL