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 vote100 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
14 votes144 views1 answer
How to export db from mysql
SQL
3 votes101 views3 answers
Mysqldump: couldn
SQL
-1 vote104 views1 answer
MYSQL stored procedure select from
SQL
-1 vote111 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote98 views2 answers
Mysql switch case
SQL
0 vote105 views1 answer
Longtext sql
SQL
1 vote96 views1 answer
How to select random rows from table
SQL
1 vote105 views1 answer
Increase existing date in sql oracle
SQL
16 votes125 views1 answer
Sql comment'
SQL