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 vote186 views1 answer
Sql gap missing values
SQL
103 votes323 views2 answers
Sql server LIKE '%%'
SQL
17 votes209 views6 answers
Sql select distinct
SQL
0 vote211 views1 answer
Mysql get date diff in months
SQL
1 vote208 views1 answer
Oracle avg
SQL
1 vote236 views1 answer
Db.Database.SqlQuery
SQL
1 vote194 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote211 views1 answer
Sql select sum group by id laravel join
SQL
0 vote239 views1 answer
Mysql streaming example
SQL
0 vote229 views1 answer
How to set up an anonymous function to variable in swift
SQL