Horje
sql subquery Code Example
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;



Sql

Related
plpgsql coalesce equivalent for empty string Code Example plpgsql coalesce equivalent for empty string Code Example
Concatenate columns in table Code Example Concatenate columns in table Code Example
how to show current database in mysql Code Example how to show current database in mysql Code Example
postgresql auto increment not working Code Example postgresql auto increment not working Code Example
in sql Code Example in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje