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 vote131 views1 answer
Oracle enable chain
SQL
10 votes139 views2 answers
Mysql drop database if exists
SQL
0 vote131 views1 answer
Mysql in clausule string array
SQL
1 vote125 views1 answer
Login to database mysql terminal
SQL
0 vote128 views2 answers
Mysql to python pandas
SQL
0 vote124 views1 answer
Add colum date in sql
SQL
0 vote134 views1 answer
Oracle shrink table
SQL
0 vote146 views1 answer
Sql server convert to guid
SQL
17 votes147 views6 answers
MySQL ORDER BY
SQL
24 votes121 views2 answers
Alter table delete column
SQL