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 vote312 views3 answers
Insert or ignore postgres
SQL
0 vote314 views2 answers
Sql update multiple tables
SQL
16 votes327 views1 answer
Mysql smallint range
SQL
1 vote321 views1 answer
Select 2 rows in sql
SQL
1 vote321 views1 answer
Sql alchemy with azuresql server
SQL
5 votes308 views2 answers
Copy data from one database to another
SQL
0 vote317 views1 answer
Mysql Like(searching in the string)
SQL
1 vote318 views3 answers
Getdate function in postgresql
SQL
6 votes324 views2 answers
Postgresql restore from dump
SQL
2 votes378 views1 answer
Tcl in sql
SQL