Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql any

Returns true if any of the subquery values meet the given condition.
Example: Returns products from the products table which have received
orders – stored in the orders table – with a quantity of more than 5.
SELECT name
FROM products
WHERE productId = ANY (SELECT productId FROM orders WHERE
quantity > 5);
Comment

SQL ANY

SELECT *
FROM Teachers
WHERE age = ANY (
  SELECT age
  FROM Students
);
Comment

PREVIOUS NEXT
Code Example
Sql :: convert varchar column to int in sql server 
Sql :: update with select postgresql 
Sql :: check lock on table in sql server 
Sql :: SQL Server lock table example 
Sql :: mysql delete duplicate rows but keep one 
Sql :: add column postgres with default value 
Sql :: how to check grants on a package in oracle 
Sql :: postgres set null 
Sql :: if null mysql 
Sql :: sum query in sql 
Sql :: use group_concat in concat 
Sql :: null sql 
Sql :: print integer and string in SQL 
Sql :: postgresql Create a new role with a username and password 
Sql :: update join sql 
Sql :: oracle drop sequence if exists 
Sql :: mysql backup database command line 
Sql :: mysql get first n characters of string 
Sql :: list all tables in postgres 
Sql :: how to check table name in current database sql 
Sql :: mysql delete database 
Sql :: mysql query with sql to get the next row 
Sql :: grant all privileges microsoft sql 
Sql :: bigquery add days to date 
Sql :: mysql limit 
Sql :: login phpmyadmin without password 
Sql :: SQL SERVER ORDER BY DATE NULL LAST 
Sql :: charindex 
Sql :: c# select Mysql 
Sql :: mysql auto increment column 
ADD CONTENT
Topic
Content
Source link
Name
7+2 =