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

3 votes394 views6 answers
DB::table('users')->get();
SQL
0 vote339 views2 answers
Close external port 3306 with iptables
SQL
8 votes352 views1 answer
Declare table variable sql server
SQL
1 vote359 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
2 votes350 views1 answer
Add new column not null sql server
SQL
-1 vote329 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote338 views1 answer
Sql server port 1434
SQL
1 vote349 views1 answer
Python escape mysql
SQL
0 vote372 views1 answer
Allow null in psql
SQL
3 votes324 views1 answer
Sql cast to integer
SQL