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 vote150 views1 answer
Sql get table last modified time
SQL
1 vote125 views1 answer
Mysql select row with max value group by
SQL
0 vote139 views1 answer
Count in sql and diff
SQL
0 vote124 views1 answer
Postgres regex word boundary
SQL
0 vote119 views1 answer
See Foreign Key
SQL
2 votes124 views1 answer
Import database in mysql command line xampp
SQL
0 vote141 views2 answers
How to install mssql on mac
SQL
1 vote123 views1 answer
Oracle stop job
SQL
5 votes132 views3 answers
Bash: mysql: command not found
SQL
0 vote120 views2 answers
SQL Server Standard
SQL