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 vote106 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote109 views1 answer
Csv to sqlite python
SQL
2 votes76 views1 answer
Sql float to int
SQL
0 vote113 views1 answer
Get number of rows in every table mysql
SQL
0 vote113 views1 answer
Database xml sql
SQL
1 vote307 views2 answers
Coderbyte sql solutions
SQL
3 votes122 views1 answer
Pl sql escape &
SQL
0 vote103 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote121 views1 answer
How to select a row in sql
SQL
0 vote118 views1 answer
Jenkins SQLCMD run
SQL