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 vote336 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote279 views1 answer
Original Query
SQL
0 vote313 views1 answer
How to add mysql to path on termin after installation
SQL
-1 vote254 views2 answers
Sql query examples
SQL
0 vote274 views2 answers
Find Overlapping sql
SQL
0 vote326 views1 answer
New rails app with mysql
SQL
1 vote318 views1 answer
Nullif postgresql
SQL
0 vote278 views1 answer
Mysql workbench procedure
SQL
11 votes259 views1 answer
Reset identity sql server
SQL
-2 votes297 views1 answer
No module named '_sqlite3
SQL