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 vote289 views1 answer
Sql select inside select sub query
SQL
0 vote314 views1 answer
Oracle current timestamp insert statement
SQL
0 vote306 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote288 views1 answer
Get number of tables in database sql
SQL
1 vote299 views1 answer
Tsql find foreign key references
SQL
2 votes308 views1 answer
Set auto increment from 1
SQL
1 vote289 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
15 votes443 views2 answers
Sql order by alphabetical
SQL
0 vote295 views1 answer
How to use group_concat in sql server
SQL
0 vote284 views1 answer
H2 auto increment and unique
SQL