The Wayback Machine - https://web.archive.org/web/20220121170033/https://www.geeksforgeeks.org/sql-some/amp/

SQL | SOME

SQL | ALL and ANY
SOME operator evaluates the condition between the outer and inner tables and evaluates to true if the final result returns any one row. If not, then it evaluates to false.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE expression comparison_operator SOME (subquery)


Instructor Table:

Name Department Salary
Chandra Computational Biology 1
Visweswaran Electronics 1.5
Abraham Computer Science 1.3
John Electronics 1.2
Samantha Computer Science 2
Jyoti Electronics 1.2
Debarka Computer Science 2
Ganesh Computational Biology 0.9

Sample Queries and Outputs:

select name
from instructor
where Salary > some(select Salary
from instructor
where dept='Computer Science');

Output:



Visweswaran
Samantha
Debarka

Explanation
The instructors with salary > (salary of some instructor in the ‘Computer Science’ department) get returned. The salaries in the ‘Computer Science’ department are 1.3, 2 and 2. This implies any instructor with a salary greater than 1.3 can be included in the final result.

Exercise: Try to write same query using ANY clause.

This article is contributed by Anannya Uberoi. If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

Article Tags :
SQL
Practice Tags :