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

9 votes391 views3 answers
Where clause sql
SQL
0 vote347 views1 answer
Get last date join sql
SQL
-2 votes372 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote393 views1 answer
How to print sql query
SQL
0 vote344 views1 answer
List mysql tables and views
SQL
0 vote341 views1 answer
What is logical database schema
SQL
0 vote435 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote349 views4 answers
Change schema in sql server
SQL
27 votes353 views4 answers
Get all tables with column name sql
SQL
0 vote346 views1 answer
Login phpmyadmin without password
SQL