In today’s article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.
One of the results from nested queries works.
General usage is as follows.
|
1 |
SELECT*FROM table_name WHERE column_name (<,=,>,=!,<>)ANY ( SELECT * FROM table_name); |
Let’s have a table with student names and let this table be named as student_all, with its number, name, and surname, and the other table with no, vize, final grades named student_vf, and using these two tables, let’s find the students with a vize grade of 38.
We will use the ANY command to do this.
|
1 |
SELECT*FROM ogrenci_all WHERE no > ANY(SELECT no FROM ogrenci_vf WHERE vize=38) |
In the plpgsql sentence above, in our first outer query, we want all the columns in the main table to come and we use the common name of the two tables in the WHERE condition to use our subquery.
Then after the ANY command is written, we open parenthesis and we specify the condition in the subquery because we say bring those with 38 visas.
We used ” > ” for Any but it has more than one parameter.
These are as follows;
=ANY: Represents the result or records equal to any of the results obtained from the subquery.
>ANY: Refers to the result obtained from the subquery or records greater than any of the results.
>=ANY: It refers to records greater than or equal to any of the subquery’s results.
<ANY: Refers to records less than any of the results from the subquery.
<=ANY: Indicates records less than or equal to any of the results obtained from the subquery.
!=ANY or <> ANY: This command is generally useless because it means different from at least one of the returned records, which means fetching all records, so we can say that it means the same as SELECT * FROM.
