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 vote313 views1 answer
Compare two tables to find unmatched records
SQL
0 vote310 views2 answers
Identity column in sql server
SQL
0 vote294 views1 answer
MySql Modify Increment
SQL
0 vote308 views1 answer
Install squirrel sql ubuntu
SQL
1 vote310 views2 answers
Postgresql get difference in hours between two dates
SQL
15 votes300 views2 answers
Open postgress in terminal mac
SQL
0 vote293 views1 answer
How to find database collation in postgres
SQL
3 votes393 views1 answer
Oracle nextval insert
SQL
0 vote297 views1 answer
Display first three characters sql
SQL
0 vote295 views2 answers
Install phoenix
SQL