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 votes235 views1 answer
Unsigned int in mysql
SQL
1 vote193 views1 answer
Oracle finding duplicate records
SQL
4 votes203 views2 answers
How to insert ip address in mysql using php
SQL
0 vote198 views1 answer
Drop CHECK constraint sql
SQL
0 vote185 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote208 views1 answer
Cube oracle
SQL
1 vote219 views1 answer
Get current date in pyspark sql
SQL
0 vote216 views2 answers
Starts and end with vowel sql
SQL
0 vote195 views1 answer
Pl sql constraint user function
SQL
0 vote237 views1 answer
Drop domain postgresql
SQL