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 vote235 views1 answer
Ms sql unique
SQL
1 vote270 views2 answers
Sql server add time to date
SQL
7 votes282 views1 answer
Oracle alter sequence restart start with
SQL
0 vote268 views1 answer
How to set sql_mode for a query in CI model
SQL
3 votes249 views3 answers
Sql current year
SQL
2 votes215 views4 answers
Mysql change database character set to utf8mb4
SQL
-1 vote255 views1 answer
Ssql to lowercqse
SQL
1 vote268 views1 answer
Tsql update datetime
SQL
0 vote275 views1 answer
Mysql delete entire row on condition
SQL
0 vote294 views1 answer
Finding leap year in sql
SQL