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

4 votes164 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote173 views1 answer
Md5 encryption for existing records
SQL
0 vote173 views1 answer
Sql server port 1434
SQL
0 vote209 views1 answer
How to get table id sequence postgres
SQL
0 vote181 views1 answer
GROUP BY postgres
SQL
1 vote176 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote153 views4 answers
Sql limit 1 offset 1
SQL
8 votes184 views1 answer
Ltrim sql
SQL
-1 vote167 views5 answers
Online sql to linq generator
SQL
0 vote159 views1 answer
Parsing float to int in mysql
SQL