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 vote238 views1 answer
Sql server select value large text
SQL
1 vote247 views3 answers
Execute sp in sql server
SQL
0 vote248 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote243 views1 answer
Set a value by excuting stored procedure
SQL
0 vote237 views1 answer
Product of a column in mysql
SQL
14 votes238 views3 answers
Sql trim from string
SQL
0 vote262 views1 answer
Oracle winter time change
SQL
0 vote270 views1 answer
Database schema for mcqs type exam in sql
SQL
1 vote232 views3 answers
How to update column name in psql
SQL
0 vote231 views3 answers
Group_concat sql server
SQL