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 vote135 views1 answer
Python list from sql
SQL
11 votes208 views2 answers
Sql between date range
SQL
0 vote131 views1 answer
Mysql workbench format date
SQL
2 votes133 views1 answer
Sql server conection string
SQL
1 vote150 views1 answer
Create index concurrently postgres
SQL
0 vote129 views1 answer
Sql count null as 0
SQL
0 vote144 views1 answer
Mysql limit order by
SQL
0 vote142 views1 answer
Check for directory in bash
SQL
1 vote133 views1 answer
Oracle duration between timestamps
SQL
0 vote130 views2 answers
Check mysql timezone
SQL