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 vote160 views1 answer
Get number of table colums in sql query
SQL
0 vote165 views1 answer
Sql gap missing values
SQL
1 vote189 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
2 votes183 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote184 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote176 views2 answers
How to find max and min salary in sql
SQL
1 vote171 views1 answer
Mysql view command
SQL
0 vote167 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote177 views1 answer
Json not contains mysql
SQL
0 vote221 views1 answer
Capabilities of sql select statements
SQL