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 vote354 views1 answer
Nvl2 syntax
SQL
1 vote356 views1 answer
Sql server loop over query
SQL
0 vote320 views1 answer
Google cloud sql postgres url example
SQL
0 vote346 views1 answer
Mysql match in serialized data
SQL
8 votes365 views2 answers
How to fetch data from database without last column
SQL
0 vote355 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
-1 vote346 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote342 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
3 votes314 views2 answers
Coalesce mysql
SQL
4 votes392 views4 answers
Mysql get date from datetime
SQL