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 vote273 views1 answer
Mysql shell set time_zone
SQL
11 votes287 views2 answers
Insert current date sql
SQL
0 vote274 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote274 views1 answer
C# check if mysql query modified rows
SQL
1 vote218 views1 answer
How to run sql script
SQL
0 vote298 views1 answer
How to generate ids in sql
SQL
2 votes268 views1 answer
Apex date today add days
SQL
0 vote291 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote299 views1 answer
Oracle table privileges
SQL
13 votes292 views1 answer
Views in sql
SQL