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

1 vote111 views3 answers
Rename table snowflake
SQL
7 votes109 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote146 views1 answer
Db.Database.SqlQuery
SQL
27 votes120 views3 answers
Mysql show tables in database
SQL
4 votes117 views1 answer
Mysql insert from local csv
SQL
0 vote116 views1 answer
Show create table in postgresql
SQL
8 votes121 views1 answer
Declare table variable sql server
SQL
0 vote127 views2 answers
Port 5432 is already in use mac
SQL
1 vote115 views1 answer
Create new table in SQL from old table with data
SQL
0 vote120 views1 answer
Set open file limit mac catalina mysql
SQL