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 vote538 views1 answer
Postgres upgrade to superuser
SQL
0 vote368 views2 answers
Psql commande \gset
SQL
14 votes366 views3 answers
Oracle sql limit results
SQL
0 vote341 views1 answer
Psql no such file or directory
SQL
1 vote349 views1 answer
Oracle rolling back transactions
SQL
0 vote360 views1 answer
Tsql generate rows
SQL
0 vote343 views1 answer
Concatenate columns in table
SQL
23 votes403 views6 answers
Create table sql server
SQL
0 vote368 views1 answer
Sql developer connect to sql server
SQL
0 vote376 views1 answer
Isnull in sqlite
SQL