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 vote404 views1 answer
How to check foreign key constraint in sql
SQL
17 votes312 views6 answers
Sql current date
SQL
3 votes314 views2 answers
WhereIn SQL
SQL
4 votes320 views1 answer
Sql group by year
SQL
0 vote313 views1 answer
How to print out column name differently in mysql
SQL
0 vote333 views1 answer
Mysql wait_timeout
SQL
5 votes320 views1 answer
Oracle scan source ddl
SQL
0 vote363 views1 answer
Check if mysql db is used
SQL
0 vote332 views1 answer
Function plsql
SQL
7 votes351 views5 answers
Max 3 salary in sql
SQL