Subquery sql

This article is tagged with: Subquery sql and mysql

subquery sql

UPDATE Book SET note= 'editore: ' + (SELECT name FROM Publisher WHERE Publisher.ID = Book.publisher)

what is subquery in sql

SUBQUERY IS NESTED QUERY INSIDE A SELECT,
INSERT OR UPDATE METHODS. OR INSIDE ANOTHER SUBQUERY

select in select sql

SELECT column-names FROM table-name1 WHERE value IN (SELECT column-name FROM table-name2 WHERE condition)

select in select sql

SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE condition

subqueries ALL sql

SELECT ProductName
FROM Products
WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);

This article is tagged with: Subquery sql and mysql