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

0 vote172 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote167 views1 answer
Min:sec datediff mssql
SQL
0 vote165 views4 answers
Restart MySQL
SQL
0 vote174 views1 answer
Java nosql sort
SQL
0 vote157 views1 answer
Truncate table sql server foreign key
SQL
0 vote167 views1 answer
Adding primery key constraint to a column
SQL
2 votes328 views5 answers
Unique in sql server
SQL
0 vote194 views1 answer
Use mysql in java program
SQL
0 vote179 views1 answer
Remove transient options sql wordpress
SQL
3 votes160 views1 answer
Index using in query plsql
SQL