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 vote219 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote192 views1 answer
Typeorm raw sql
SQL
0 vote322 views1 answer
Mysql select field if condition
SQL
59 votes7.7K views6 answers
Alter table sql
SQL
1 vote201 views1 answer
Tsql get beginning of year
SQL
1 vote202 views3 answers
Epoch to datetime
SQL
4 votes197 views5 answers
Primary key
SQL
0 vote330 views4 answers
Stored procedure sql
SQL
27 votes219 views3 answers
Mysql show tables in database
SQL
0 vote182 views1 answer
Uuid sqlalcomany
SQL