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

7 votes120 views2 answers
Sql remove duplicates based on column
SQL
3 votes119 views2 answers
How to open postgresql in windows
SQL
0 vote101 views1 answer
Lost connection to mysql
SQL
0 vote71 views1 answer
Count char in java
SQL
10 votes104 views4 answers
How to alter table name in mysql
SQL
1 vote151 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote111 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote107 views2 answers
Mysql spring boot application.properties
SQL
0 vote110 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote103 views1 answer
Uuid sqlalcomany
SQL