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

1 vote160 views2 answers
Test sqlsrv connection
SQL
-1 vote112 views1 answer
Mysql how to set update or create
SQL
0 vote154 views1 answer
Sql tabelle erstellen
SQL
0 vote165 views1 answer
Test database for sql
SQL
1 vote165 views1 answer
Mysql select from outside
SQL
0 vote161 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote163 views1 answer
Select not matching data from two tables
SQL
1 vote151 views2 answers
Install mysqldump ubuntu
SQL
0 vote148 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
1 vote154 views1 answer
Sql bitwise operators
SQL