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 votes321 views1 answer
Delete all content in table mysql
SQL
0 vote346 views1 answer
Normalization in database 2nd normal form
SQL
0 vote355 views1 answer
In query in sql
SQL
0 vote335 views1 answer
Create table with timestamp mysql youtube
SQL
2 votes378 views1 answer
Where clause for child record apex
SQL
0 vote349 views1 answer
DATEDIFF minute postgres
SQL
1 vote372 views1 answer
Isnull sql server
SQL
0 vote367 views1 answer
Sql max of two values
SQL
0 vote322 views1 answer
Mysqlimport
SQL
0 vote377 views1 answer
GROUP BY postgres
SQL