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

3 votes134 views1 answer
Oracle list user grants
SQL
1 vote154 views1 answer
Sql drop schema
SQL
2 votes146 views2 answers
Mysql get time from datetime
SQL
1 vote141 views2 answers
Mysql: command not found
SQL
1 vote138 views2 answers
Mysql spring boot application.properties
SQL
0 vote138 views1 answer
Mysql find missing values
SQL
0 vote163 views1 answer
Postgres change the name of schema
SQL
2 votes182 views2 answers
How to check data type in sql server
SQL
0 vote174 views1 answer
Alter domain sql
SQL
0 vote151 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL